jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 12th, 2006

There is no "update cascade" functionality in oracle. But you can develop your own code to achieve this. The source code is also available in this urlhttp://asktom.oracle.com/tkyte/update_cascade/index.html

Answer Question  Select Best Answer

Instrument

 Profile Answers by Instrument Questions by Instrument

• Mar 18th, 2007

A nested loop is a loop within a lop, an inner loop within the body of an outer one. How this workds is that the first pass of the outer loop triggers the innter which executes to completion. Then the...

Answer Question  Select Best Answer

Manikandan

• Dec 24th, 2006

Use execute immediate to write DDL statements.but you should have create  system previlege on the schema.

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Jan 5th, 2007

Hi,  It is very good query u asked.The work around is, it is not advisable to use a COMMIT inside the loop as it invalidates the cursor which is declared for update.If u want to use commit then d...

Answer Question  Select Best Answer

Brajesh Singh Bhadoriya

 Profile Answers by Brajesh Singh Bhadoriya Questions by Brajesh Singh Bhadoriya

• Jan 15th, 2007

hi...actually the IN parameters are the read only parameters hence we can't assign any value to them but for out parameters its not true, as we can assign value to OUT parameters. so the procedur...

Answer Question  Select Best Answer

saurabh kumar verma

• Jan 19th, 2007

Cursor is basically a pointer as it's like a address of virtual memory which is being used storage related to sql query & is made free after the values from this memory is being used.

Answer Question  Select Best Answer

Hi all I wrote a procedure to send email via plsql procedure, It was compiled successfully but not working ....

here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on )

PL/SQLcreate or replace PROCEDURE send_test_message
IS
mailhost VARCHAR2(64) := 'mail.cmcltd.com';
sender VARCHAR2(64) := 'akash.sharma@cmcltd.com';

KiranKW

 Profile Answers by KiranKW Questions by KiranKW

• May 3rd, 2007

Hi,   I dont see any problem with your code ... try to capture the return code for each of the calls ... that will help to identify the exact problem

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 9th, 2007

There is no limitation on the number of Subprograms in the package, but there is a limitation on the compiled file size in the database.

Answer Question  Select Best Answer

godsrikanth

 Profile Answers by godsrikanth Questions by godsrikanth

• Dec 3rd, 2009

Difference is in performance.  API is a package call which will process faster since its already compiled.  It can be called globally.  Stored PL/SQL call is not compiled into memory and may take more time.

Answer Question  Select Best Answer

Ravindra Reddy

• Sep 5th, 2007

Cursor is a private SQL area.. its a temporary buffer used to hold the
transactional data on it n used to manipulate multiple rows through PL/SQL block
statements.
Temporary table can hold the records permanently and we can do DML operations
on this..
ok
Cheers
Rav'i'ndra Reddy

Answer Question  Select Best Answer

Meera

• Jul 4th, 2007

The internal table is a table which is getting filled during the run time of the program...and after that there wont exist any value in that internal table whereas table is the one which contains data permanently

Answer Question  Select Best Answer

rsundararajan_in

• Jul 30th, 2007

By using wrapper class pl sql code can be protected.

Answer Question  Select Best Answer

dearvandna

• Sep 21st, 2007

No. but maybe associative arrays can help

Answer Question  Select Best Answer

nitingalande

 Profile Answers by nitingalande Questions by nitingalande

• Jan 13th, 2008

OCI stands for Oracle Call Interface, it is a interface api used to access oracle database from C programs. Data Guard stands for it is multiple DB servers enviornment configured for Physical as well ...

Answer Question  Select Best Answer

Rushikesh

• Sep 25th, 2007

To be callable from SQL statements, a stored function must obey the following "purity" rules, which are meant to control side effects:1. When called from a SELECT statement or a paralle...

Answer Question  Select Best Answer

dearvandna

• Sep 21st, 2007

Normally use it as sql%type or sql%rowtype. But if you are using a cursor then use it cursorname%type or cursorname%rowtype.

Answer Question  Select Best Answer

jayanthanr

 Profile Answers by jayanthanr Questions by jayanthanr

• Jan 8th, 2008

To created flat files, or read flat files in a procedure or function, the built-ins in the UTL_FILE package can be used.

Answer Question  Select Best Answer

archie123

• Aug 28th, 2007

Yes you can use commit or rollback in exception block;select * from test123;A----------51 Declare s varchar2(2); Begin update test123 set a = a+10; select a into s from test123 where a=20; exception...

Answer Question  Select Best Answer

amahanit

 Profile Answers by amahanit Questions by amahanit

• Dec 1st, 2007

There are hundreds of build-ins avialable few ones areDBMS_OUTPUT.PUT_LINE, DBMS_SQL, DBMS_DDL, DBMS_PIPE, DBMS_JOB

Answer Question  Select Best Answer

devi123

• Sep 25th, 2007

Declare the collection variable (varrys or PL/SQL tables)?as out parameter for the procedure and fetch the result set into collection variable.

Answer Question  Select Best Answer