Messages posted by: LewisC

I cannot install the express version due to the amount of memory and such on my laptop. Instead of looking at what the laptop has, can you not limit the software so that it will only use 1 gig of ram and 1 cpu? Do I need to run a virtual server just to run EDB?

Thanks,

LewisC

When will GridSQL be available for download? Same for documentation?

Thanks,

LewisC

What tool/tools would you recommend for profiling an SPL program? I'd like to see timings for procedural calls and sql, as well as waits if possible.

Thanks,

LewisC

I am running an online migration of an application and am getting an error on all of my views:

Creating View: PROJECT_TASKS
Error Creating View PROJECT_TASKS: ERROR: invalid message format
Creating View: PROJECT_RESOURCES
Error Creating View PROJECT_RESOURCES: ERROR: invalid message format
Creating View: PROJ_HOURS_REMAIN_BY_RESOURCE
Error Creating View PROJ_HOURS_REMAIN_BY_RESOURCE: ERROR: invalid message format
Creating View: PROJ_HOURS_REMAINING
Error Creating View PROJ_HOURS_REMAINING: ERROR: invalid message format
Creating View: HOURS_WORKED_BY_RESOURCES
Error Creating View HOURS_WORKED_BY_RESOURCES: ERROR: invalid message format

A sample view is:

CREATE OR REPLACE VIEW hours_worked_by_resources AS
SELECT tt_projects_tasks.project_task_name, tt_projects_tasks.estimated_hours,
tt_resources.resource_name, tt_task_item_update.hours_worked,
tt_task_item_update.item_date
FROM tt_tasks JOIN tt_projects_tasks
ON (tt_tasks.task_id = tt_projects_tasks.task_id)
JOIN tt_tasks_resources
ON (tt_tasks.task_id = tt_tasks_resources.task_id)
JOIN tt_resources
ON (tt_resources.resource_id = tt_tasks_resources.resource_id)
LEFT OUTER JOIN tt_task_item_update
ON (tt_tasks_resources.task_id = tt_task_item_update.task_id)
AND (tt_tasks_resources.resource_id = tt_task_item_update.resource_id)

Any idea why this is not working? It's simple enough to compile the views manually in EDB but I am curious as to why they are failing.

Thanks,

LewisC

Can you let me know what this error message means:

ERROR: EDB-0A000: input of anonymous composite types is not implemented at Where: SPL Procedure "FOPEN" while casting return value to function's return type

I'm calling a packaged function with a record variable as an input. Does this error mean that record variables are not allowed as parameters?

Thanks,

LewisC

I am trying to call the dblink_ora_call and it is failing with ORA-24374. Everything else is working, just the call fails.

It looks like a change to OCI in 10g. You can read more here:

http://forums.oracle.com/forums/thread.jspa?messageID=1488300

Thanks,

LewisC

When I try to schedule a job, I am getting a red message at the top of the screen, Message Not Acknowledged. Any ideas? The code I am adding is a basic insert that runs fine from SQL Interactive.

Thanks,

LewisC

Hi,

I can't seem to run the management server. I get an error:

Could not establish an encrypted connection becuase the certificate presented by localhost has an invalid signature.

Any ideas?

Thanks,

LewisC

Merry Christmas!

The create table wizard (select tables, right click, select create table), does not allow Oracle data types when creating tables.

Is that a bug or by design?

Thanks,

LewisC

I can't get this to compile and I can't figure out why:

CREATE OR REPLACE PACKAGE global_pkg
AS
g_var CONSTANT NUMBER := 1.03;
END;

I get ERROR: syntax error at or near "NUMBER" at Position: 63

Thanks,

LewisC

Oracle allows nested named blocks, i.e.

CREATE PROC AS
PROCEDURE what AS
BEGIN
NULL;
END;
BEGIN
NULL;
END;

This doesn't appear to work in EDB. It compiles but gets an error at runtime. Is this supposed to work? If not, any idea of when it will work?

Thanks,

LewisC

I posted a comment to my earlier post but didn't get a reply. I posted an error in a case statement and the solution was a newer version of EDB but I have the newer version and I getting te same error.

Are there still issues wth case expressions in 8.1.5.21?

LewisC

Hi,

I'm trying to understand why I am getting the results that I am getting.

I would expect that if I issue a RAISE no_data_found; I could check for the no_data_found exception in my exception handler. That is not working.

BEGIN RAISE no_data_found;
EXCEPTION
WHEN no_data_found THEN
DBMS_OUTPUT.PUT_LINE('Error: ' || SQLCODE ||
', ' || SQLERRM );
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Other Error: ' || SQLCODE ||
', ' || SQLERRM );
END;

I would expect the WHEN no_data_found to fire but instead, I am getting this output:

INFO: Other Error: P0001, EDB-P0001: no_data_found

I get the same results view edb-pgsql or through developer studio. I am using 8.1.5.21. I have tried it on both linux and windows.

I get the same from all of the exceptions that I have explicitly raised.

Thanks,

LewisC

Is there a list of all the predfined, named exceptions available in EDB? Like NO_DATA_FOUND, DUPE_VAL_ON_INDEX, etc?

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

I like the new look for developer studio. I like several of the improvements, also.

One thing that I think would be very useful is to add a data tab when looking at a table or view so that the user doesn't need to launch SQL Interactive to see the data. Just click on the tab and there it is. Most other DB browsers support that functionality.

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

I understand about raise_application_error but is it possible to define my own named exceptions? Also, is there anyway to associate a code to an exception for propagation?

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

Are SPL programs compiled at runtime? I have some bad code that compiles fine but shows what looks like a compilation error at run time.

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

The errors that I am getting are less than useful. Can I recommend that Developer Studio include line numbers in the display? It would make the error messages more usable.

But anyway, can you see why this case statement is not working? I'm just not seeing what the problem is. I have tried it as both a selector based case and a searched case and it fails either way:

DECLARE
v_var1 NUMBER := 3;
v_var2 VARCHAR2(50);
BEGIN

v_var2 :=
CASE v_var1
WHEN 1 THEN 'v_var1 = 1'
ELSE 'v_var1 NOT IN (1,2,3,4)'
END;

DBMS_OUTPUT.PUT_LINE( v_var2 );

END;

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

This code should work and does not:

DECLARE
TYPE a_tab IS TABLE OF VARCHAR2(30) -- Line 1
INDEX BY BINARY_INTEGER; -- Line 2

TYPE r_rec IS RECORD ( -- Line 3
abc NUMBER ); -- Line 4

BEGIN
NULL;
END;

If you remove lines 1 and 3, it will work:

DECLARE
TYPE a_tab IS TABLE OF VARCHAR2(30)
INDEX BY BINARY_INTEGER; -- Line 2

TYPE r_rec IS RECORD (
abc NUMBER ); -- Line 4

BEGIN
NULL;
END;

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

I'm running a query and getting the same results (for dates) with and without the FM format modifier. It seems to be working for numbers though.

When I run the query in Oracle is works as I expect.

Here is the query and output:

edb=# SELECT ename,
edb-# to_char(sal, 'FM L9G999G990D00') salary,
edb-# to_char(hiredate, 'FM Day, DD MONTH, YEAR') hire_Date
edb-# FROM emp
edb-# WHERE ename = 'MARTIN';
ename | salary | hire_date
--------+------------+----------------------------------------------------------------
MARTIN | $1,250.00 | Monday , 28 SEPTEMBER , ONE THOUSAND NINE HUNDRED EIGHTY ONE
(1 row)

edb=#
edb=# SELECT ename,
edb-# to_char(sal, 'L9G999G990D00') salary,
edb-# to_char(hiredate, 'Day, DD MONTH, YEAR') hire_Date
edb-# FROM emp
edb-# WHERE ename = 'MARTIN';
ename | salary | hire_date
--------+----------------+---------------------------------------------------------------
MARTIN | $ 1,250.00 | Monday , 28 SEPTEMBER , ONE THOUSAND NINE HUNDRED EIGHTY ONE
(1 row)

edb=#

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide/

I have a package in my database but edb_Package is emtpy. What is this view for?

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

I have 4 procedures and 1 package defined in my database but the ALL_OBJECTS view shows only tables and indexes. Why is that? If that view doesn't show all objects, what objects does it show?

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

Is it possible to install pgtcl in EDB?

I tried but it doesn't find the lnaguage file.

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

Any idea when SQL Analytics will be supported in EDB? Analytics are the functions with the OVER() syntax, i.e. COUNT(*) OVER(PARTITION BY key)

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide

What level of XML Support is currently provided in EDB? I thought I had read that it was full XMLType support but I can't find anything in the docs.

I'm specifically looking for XMLType and the SQL/X Functions: XMLElement, XMLForest, etc.

Thanks,

LewisC
http://blogs.ittoolbox.com/oracle/guide