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

Vaibhav Tyagi

• Sep 25th, 2007

You cannot move existing table into a cluster. You can create new tables though, including tables with the same contents as existing tables. In the second. form, query returns a set of rows which...

Answer Question  Select Best Answer

dinu78

 Profile Answers by dinu78 Questions by dinu78

• Dec 21st, 2007

1) First identify the current excecution plan by using showplan.In most cases, creating and then forcing usage of the indexes result in drastic improvement.1) Ensure that indexes(single or composite)&...

Answer Question  Select Best Answer

we have a PRIMARYKEY field with auto generation in sequence of a table of records. If we delete any one of records from the table, how can we update the table implicitly using Trigger?

amahanit

 Profile Answers by amahanit Questions by amahanit

• Dec 1st, 2007

Which table u want to update ,in case if it is the same table then write after delete  trigger on the table and select values from destination table.

Answer Question  Select Best Answer

SELECT APE.DAT_INSERT_DATE as "Payment Entry Date", Case when APE.TXT_INTERMEDIARY_CD is null or APE.TXT_PAYER_CUSTOMER_ID APE.TXT_INTERMEDIARY_CD then (Select TXT_CUSTOMER_NAME from GENMST_CUSTOMER where TXT_CUSTOMER_CD = APE.TXT_PAYER_CUSTOMER_ID) else(Select TXT_INTERMEDIARY_NAME from GENMST_INTERMEDIARY where TXT_INTERMEDIARY_CD = APE.TXT_PAYER_CUSTOMER_ID) End as "Payer Name" , APE.TXT_PAYER_CUSTOMER_ID...

joybanerjee

 Profile Answers by joybanerjee Questions by joybanerjee

• Dec 20th, 2007

create or replace procedure sql_to_procedure as declare cursor c1 is SELECT APE.DAT_INSERT_DATE as "Payment Entry Date",APE.TXT_INTERMEDIARY_CD AS "Intermediary ID",APE.TXT_PAYER_C...

Answer Question  Select Best Answer