Email Alerts
-
Tool in Oracle 10g to keep track of execution of queries
How can I keep track of the execution of stored procedures, functions and queries in Oracle 10g, as I used to do using SQL Server Profiler? Is there any tool in 10g for this purpose? Ask the Expert
-
Execute SQL statement from table in other schema
I want to execute SQL statements that use other schema tables from my stored procedure. The stored procedure is in one schema and the table is in the other schema. I am getting the "ORA-01031: insufficient privileges" error. Ask the Expert
-
ORA-04082: NEW or OLD references not allowed in table level triggers
I am calling a stored procedure from a trigger. It shows the error: "ORA-04082: NEW or OLD references not allowed in table level triggers." Ask the Expert
-
Oracle updates free Web development tool
Oracle Application Express now offers Microsoft Access migration and .pdf printing support. Article
-
Mike Ault's Oracle "good practices": Oracle coding
Mike Ault offers "good practices" for Oracle coding, including using array processing, placing code within stored procedures and using proper variable types for variable declaration. Tip
-
I get ORA-01401 error, my friend does not
I created a table and procedure. When I run it I get the ORA-01401 error. My friend who has Oracle 10g on Windows XP runs the procedure and does not get any error -- why? Ask the Expert
-
Could PL/SQL procedures fail after OS migration?
Could our PL/SQL procedures fail on a new OS after migration? Ask the Expert
-
Invalid stored procedures
When running an application that is connected to an Oracle server/database and trying to add rows or make a call to the DB, I am getting various errors that the stored procedures are invalid. Ask the Expert
-
Finding size of files in BLOB datatype
I have a table named DOCUMENT with a BLOB datatype for storing files. I want a query to find the size of each file stored in that BLOB object. Ask the Expert
-
PLS errors after adding columns to table
I altered a table and added two columns. I ran reference type as tablename%rowtype in stored procedures. I got two error messages: "PLS-00302: component 'NUMLABEL' must be declared" and "PLS-00417: unable to resolve 'NUMLABEL' as a column." Ask the Expert