I have set up a cursor with a list of procedure names (and their appropriate parameters) that need to be executed.
How can I execute these procedures in another procedure when I'm getting the n...
http://www.experts-exchange.com/Database/Oracle/Q_20128479.html
Zones:
OracleDate Answered: 06/01/2001 Rating: 6.4 Views: 0
Greetings.
I am using 4.0.2.410 of PL/SQL Developer. I have a PL/SQL program that, when I compile it, gives me a PLS-000123 error. Now, I can compile this same program against a 7.3.4 db, and an...
http://www.experts-exchange.com/Database/Oracle/Q_20181970.html
Zones:
OracleDate Answered: 09/14/2001 Rating: 7.8 Views: 4
I wish to work with arrays in pl/sql
language, also using loops and 'for'
conditions?
maybe somebody know how arrays are written in pl/sql?
http://www.experts-exchange.com/Database/Oracle/Q_10321523.html
Zones:
OracleDate Answered: 04/06/2000 Rating: 6.8 Views: 0
Is it possible in SQL to read whole table with nested table into the scalar variables (not row by row in PL/SQL)?
I have the object type:
CREATE TYPE res_period_cnt AS OBJECT (
res_period number...
http://www.experts-exchange.com/Database/Oracle/Q_10324381.html
Zones:
OracleDate Answered: 04/10/2000 Rating: 7.4 Views: 0
Is there any way to select from a refcursor in sql_plus?
If I run this at the sql prompt, can I select from the :cur bind variable to see what's in the dynaset?
EXEC SCHEMA.PACKAGE.PROC('122...
http://www.experts-exchange.com/Database/Oracle/Q_20220987.html
Zones:
OracleDate Answered: 03/07/2002 Rating: 7.2 Views: 0
I have a stored proc that has an order by variable as one of the parameters, but the sql statment won't work with it. I've tried passing the field name and the field number. Below is a partial proc...
http://www.experts-exchange.com/Database/Oracle/Q_20221146.html
Zones:
OracleDate Answered: 11/01/2001 Rating: 7.6 Views: 0
Hi,
I am using oracle9i and jdk1.4.0. I want to write a trigger that fires when a row is inserted into the table. When the trigger fires it should call a java program. I want to know how to loa...
http://www.experts-exchange.com/Database/Oracle/Q_20548570.html
Zones:
OracleDate Answered: 01/19/2004 Rating: 8.0 Views: 0
I have a web application runs in websphere. It has a massive calculation engine. So when i call that calculation from the front-end(jsp) it takes sevral seconds to complete the calculation. At this...
http://www.experts-exchange.com/Programming/Misc/Q_20548889.html
Zones:
ProgrammingDate Answered: 10/07/2003 Rating: 8.0 Views: 0
Hello there,
I need to create a procedure that compares a variable to the values in a table.
The variable(lets call it varX) needs to be hold the following values in a incremention fashion ...
http://www.experts-exchange.com/Database/Oracle/Q_21220557.html
Zones:
OracleDate Answered: 11/27/2004 Rating: 9.4 Views: 0
I'm having some issues with .PLS files and some investigating leads me to believe that setting a MIME type on the server would remedy this.
A .PLS is a playlist file that tells a client where a ...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/Apache/Q_21281327.htm...
