Home » SQL & PL/SQL » SQL & PL/SQL » procedure execution
procedure execution [message #353098] Sat, 11 October 2008 06:05 Go to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
I have written one procedure while compling i will not shown any error while run the procedure it will show the error which is given bellow.

create or replace procedure as risi(pay varchar2,acc varchar2,sisi varchar2,amt number,ret out ei%rowtype)
as

sqlquery varchar2(500);
TYPE ref_typ IS REF CURSOR;
reftyp ref_typ;
begin

sql_query :='select pay,acc,amt from ei';

if (pay is not null) then
 sql_query := sql_query ||' '||'payee='||pay;
elsif (acc is not null) then
 sql_query:=sql_query||' '||'account ='||'acc';
end if;
sql_query:=sql_query||';';
OPEN reftyp FOR sql_query;
FETCH reftyp into ret;
CLOSE reftyp;
END ;

end;


while run the procedure with the below script it will give the error as

declare
retvar ei%rowtype;
begin
risi('ASHA','12121','ashok',1234,retvar);
dbms_output.put_line('Payee is '||retvar.pay);
end;


Error shown as

ERROR at line 6 :
ORA-06550 : line 6,column 46;
PLS-00487 : Invalid reference to variable 'RETVAR'
ORA-06550 : line 6,column 3;
PL/SQL : statement ignored


can anyone help me to sort this is very urgent one


[Updated on: Sat, 11 October 2008 07:01]

Report message to a moderator

Re: procedure execution [message #353107 is a reply to message #353098] Sat, 11 October 2008 08:27 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You should not post fake-code and pretend it's the real thing.
The procedure you posted will not compile. You probably made some errors while simplifying and anonymizing the code, but you left behind a mess.
sqlquery vs sql_query, no "WHERE" keyword in the dynamic sql.

Now first fix your code, then show a complete sqlplus copy-paste showing you executing the anonymous block.
Re: procedure execution [message #353117 is a reply to message #353098] Sat, 11 October 2008 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.

You should also read read OraFAQ Forum Guide.

Regards
Michel
Re: procedure execution [message #353588 is a reply to message #353117] Tue, 14 October 2008 04:51 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
I have pasted here is the complete code can anyone sort this error which i am getting.

CREATE OR REPLACE PROCEDURE RISI_ADV_SRCH_SAM
(
      payment_cen   varchar2,
      account_no    varchar2,
      entry_type    varchar2,
      ref_no        varchar2,
      ref_typ       varchar2,
      filename      varchar2,
      curr          varchar2,
      amtfrm        number,
      amtto         number,
      case_txn_fdt  date,
      case_txn_tdt  date,
      value_fdt     date,
      value_tdt     date,
      inv_typ       varchar2,
      invsts        varchar2,
      transflg      varchar2,
      funcind       varchar2,
      usr_id        varchar2,
      grp_id        varchar2,
      cus_id        varchar2,
      ret       out sys_refcursor
)
AS

sql_query         varchar2(500);
sql_slctclause    varchar2(50) ;
sql_frmclause     varchar2(50) ;
sql_whrclause     varchar2(500);

retrec            varchar2(1000);


TYPE ADV_SRC IS REF CURSOR;
advsrc        ADV_SRC;
retrec        EI_SAV%ROWTYPE;

v_paycen       ei_sav.payment_centre%type;
v_acno         ei_sav.account_no%type;
v_enttyp       ei_sav.entry_type%type;
v_refno        ei_sav.ref_number%type;
v_reftyp       ei_sav.ref_type%type;
v_fname        ei_sav.searchname%type;
v_cur          ei_sav.currency%type;
v_amtfrom      ei_sav.amount_from%type;
v_amtto        ei_sav.amount_to%type;
v_casefdt      ei_sav.case_trans_from_dt%type;
v_casetdt      ei_sav.case_trans_to_date%type;
v_valuefdt     ei_sav.value_from_date%type;
v_valuetdt     ei_sav.value_to_date%type;
v_invtyp       ei_sav.inv_type%type;
v_invstatus    ei_sav.invstatus%type;
v_transflg     ei_sav.trans_flg%type;
v_funind       ei_sav.func_ind%type;
v_usrid        ei_sav.userid%type;
v_grpid        ei_sav.groupid%type;
v_cusid        ei_sav.cust_id%type;

Begin  --{

if (payment_cen is null) then
 dbms_output.put_line('Payment Centre Should Not Be Null') ;
End if;

if (acc_no is null) then
  dbms_output.put_line('Account Number Should Not Be Null');
End if;

if (filename is null) then
  dbms_output.put_line('Account Number Should Not Be Null');
End if;

if ( transflg = 'TXNSR') OR (transflg = 'INVSR')   then   --{
      update EI_SAV set payment_centre=payment_centre,account_no=acc_no,entry_type=ent_typ,
                               ref_number=ref_no,ref_type=ref_typ,searchname=filename,currency=curr,
                               amount_from=amtfrm,amount_to=amtto,case_trans_from_dt=case_txn_fdt,
                               case_trans_to_date=case_txn_tdt,value_from_date=value_fdt,value_to_date=value_tdt,
                               inv_type=inv_typ,invstatus=invsts,trans_flg=transflg,func_ind=funcind
                          where userid = usr_id and account_no = acc_no and groupid = grp_id and cust_id = cus_id;
     If (SQL%NOTFOUND) then
       insert into EI_SAV (cust_id,groupid,userid,invstatus,searchname,payment_centre,account_no,
                                    entry_type,ref_type,ref_number,inv_type,currency,amount_from,amount_to,
                                    case_trans_from_dt,case_trans_to_date,value_from_date,value_to_date,trans_flg,func_ind)

                           VALUES (cus_id,grp_id,usr_id,invsts,filename,payment_cen,acc_no,ent_typ,ref_typ,
                       ref_no,inv_typ,curr,amtfrm,amtto,case_txn_fdt,case_txn_tdt,value_fdt,value_tdt,transflg,funcind);
     End if;

End if ;       --}

   sql_slctclause := 'SELECT payment_centre,account_no,entry_type,invstatus,searchname,ref_type,ref_number,
                        inv_type,currency,amount_from,amount_to,case_trans_from_dt,case_trans_to_date,
                        value_from_date,value_to_date,func_ind';


   sql_frmclause :=' FROM'||' '||'EI_SAV ';

dbms_output.put_line('the query is '||sql_slctclause||sql_frmclause);

 if ( payment_cen is not null ) then
      sql_whrclause:='WHERE'||' '||'payment_centre='||''''||payment_cen||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if;
   if (invsts is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'invstatus ='||''''||invsts||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (filename is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'searchname ='||''''||filename||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (acc_no is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'account_no ='||''''||acc_no||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (ent_typ is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'entry_type ='||''''||ent_typ||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (ref_typ is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'ref_type ='||''''||ref_typ||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (ref_no is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'ref_number ='||''''||ref_no||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (inv_typ is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'inv_type ='||''''||inv_typ||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (curr is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'currency ='||''''||curr||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if;
   if (amtfrm is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'amount_from ='||''''||amtfrm||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (amtto is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'amount_to ='||''''||amtto||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (case_txn_fdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'case_trans_from_dt ='||''''||case_txn_fdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (case_txn_tdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'case_trans_to_date ='||''''||case_txn_tdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;
   if (value_fdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'value_from_date ='||''''||value_fdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;
   if (value_tdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'value_to_date ='||''''||value_tdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;
   if (funcind is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'func_ind ='||''''||funcind||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;


  sql_query:=sql_slctclause||sql_frmclause||sql_whrclause;

  retrec := sql_query;
dbms_output.put_line('Entire Query is '||retrec);

  return ;

   OPEN advsrc FOR sql_query;

    FETCH advsrc INTO retrec;

    CLOSE advsrc;

End;  --}


==============================

Error

==============================

SQL> @scrpt_sam.sql
 10  /
RISI_ADV_SRCH_SAM('HK','121212','kasdjfkl','23121','asldfj','scb','JPY','1234','2345','10-DEC-2008','10-DEC-2008','10-DEC-2008','10-DEC-2008','sdfjlasjdl','sts','qwer','om','scbusr','scbcust','scbgrp',outpar);
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PLS-00306: wrong number or types of arguments in call to 'RISI_ADV_SRCH_SAM'
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored

=============================
Re: procedure execution [message #353591 is a reply to message #353098] Tue, 14 October 2008 04:57 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't see a declaration of outpar anywhere.
While you're at it numbers shouldn't be in quotes and you should use to_date for the date parameters.
Re: procedure execution [message #353597 is a reply to message #353591] Tue, 14 October 2008 05:15 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
the error i pasted here is from sql*plus and my entire execute scripts are in the filename
scrpt_sam.sql
as
declare 
     outpar ei_sav%rowtype;
Begin
  RISI_ADV_SRCH_SAM('HK','121212','kasdjfkl','23121','asldfj','scb','JPY','1234','2345','10-DEC-2008','10-DEC-2008','10-DEC-2008','10-DEC-2008','sdfjlasjdl','sts','qwer','om','scbusr','scbcust','scbgrp',outpar);
End;
Re: procedure execution [message #353598 is a reply to message #353588] Tue, 14 October 2008 05:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Your whole procedure looks kinda useless..
You never assign a value to ret.


In response of you posting your calling script:

ei_sav%rowtype; is NOT the same type as sys_refcursor

[Updated on: Tue, 14 October 2008 05:18]

Report message to a moderator

Re: procedure execution [message #353631 is a reply to message #353598] Tue, 14 October 2008 07:16 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
Can i give that declaration of the out parameter as

ret       out ei_sav%rowtype;



Why you say its useless can you breif that

[Updated on: Tue, 14 October 2008 07:17]

Report message to a moderator

Re: procedure execution [message #353633 is a reply to message #353098] Tue, 14 October 2008 07:24 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
I think you need to read up on ref cursors in the documentation because, looking at the code, you don't seem to understand how they work.

Frank has already pointed out a couple of problems, but here are a few more.

You've got an open/fetch/close on a ref cursor at the end of procedure.
This will never run as the return statement prevents the code being executed.

Assuming you remove the return it's still not going to work as:
a) you need to open the out parameter ref cursor, not some other one.
b) there is absolutely no point fetching and closing a ref cursor in the procedure that created it.

The whole point of ref cursors is to return data to another program (another stored procedure or something else).
If you fetch and close the cursor the other program will not be able to access the contents of the cursor.
Re: procedure execution [message #353637 is a reply to message #353633] Tue, 14 October 2008 07:41 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
I have comment the two statements FETCH and CLOSE in the procedure but i still getting that error.

Please correct me.


CREATE OR REPLACE PROCEDURE RISI_ADV_SRCH_SAM
(
      payment_cen   varchar2,
      account_no    varchar2,
      entry_type    varchar2,
      ref_no        varchar2,
      ref_typ       varchar2,
      filename      varchar2,
      curr          varchar2,
      amtfrm        number,
      amtto         number,
      case_txn_fdt  date,
      case_txn_tdt  date,
      value_fdt     date,
      value_tdt     date,
      inv_typ       varchar2,
      invsts        varchar2,
      transflg      varchar2,
      funcind       varchar2,
      usr_id        varchar2,
      grp_id        varchar2,
      cus_id        varchar2,
      ret       out sys_refcursor
)
AS

sql_query         varchar2(500);
sql_slctclause    varchar2(50) ;
sql_frmclause     varchar2(50) ;
sql_whrclause     varchar2(500);

retrec            varchar2(1000);


TYPE ADV_SRC IS REF CURSOR;
advsrc        ADV_SRC;
retrec        EI_SAV%ROWTYPE;

v_paycen       ei_sav.payment_centre%type;
v_acno         ei_sav.account_no%type;
v_enttyp       ei_sav.entry_type%type;
v_refno        ei_sav.ref_number%type;
v_reftyp       ei_sav.ref_type%type;
v_fname        ei_sav.searchname%type;
v_cur          ei_sav.currency%type;
v_amtfrom      ei_sav.amount_from%type;
v_amtto        ei_sav.amount_to%type;
v_casefdt      ei_sav.case_trans_from_dt%type;
v_casetdt      ei_sav.case_trans_to_date%type;
v_valuefdt     ei_sav.value_from_date%type;
v_valuetdt     ei_sav.value_to_date%type;
v_invtyp       ei_sav.inv_type%type;
v_invstatus    ei_sav.invstatus%type;
v_transflg     ei_sav.trans_flg%type;
v_funind       ei_sav.func_ind%type;
v_usrid        ei_sav.userid%type;
v_grpid        ei_sav.groupid%type;
v_cusid        ei_sav.cust_id%type;

Begin  --{

if (payment_cen is null) then
 dbms_output.put_line('Payment Centre Should Not Be Null') ;
End if;

if (acc_no is null) then
  dbms_output.put_line('Account Number Should Not Be Null');
End if;

if (filename is null) then
  dbms_output.put_line('Account Number Should Not Be Null');
End if;

if ( transflg = 'TXNSR') OR (transflg = 'INVSR')   then   --{
      update EI_SAV set payment_centre=payment_centre,account_no=acc_no,entry_type=ent_typ,
                               ref_number=ref_no,ref_type=ref_typ,searchname=filename,currency=curr,
                               amount_from=amtfrm,amount_to=amtto,case_trans_from_dt=case_txn_fdt,
                               case_trans_to_date=case_txn_tdt,value_from_date=value_fdt,value_to_date=value_tdt,
                               inv_type=inv_typ,invstatus=invsts,trans_flg=transflg,func_ind=funcind
                          where userid = usr_id and account_no = acc_no and groupid = grp_id and cust_id = cus_id;
     If (SQL%NOTFOUND) then
       insert into EI_SAV (cust_id,groupid,userid,invstatus,searchname,payment_centre,account_no,
                                    entry_type,ref_type,ref_number,inv_type,currency,amount_from,amount_to,
                                    case_trans_from_dt,case_trans_to_date,value_from_date,value_to_date,trans_flg,func_ind)

                           VALUES (cus_id,grp_id,usr_id,invsts,filename,payment_cen,acc_no,ent_typ,ref_typ,
                       ref_no,inv_typ,curr,amtfrm,amtto,case_txn_fdt,case_txn_tdt,value_fdt,value_tdt,transflg,funcind);
     End if;

End if ;       --}

   sql_slctclause := 'SELECT payment_centre,account_no,entry_type,invstatus,searchname,ref_type,ref_number,
                        inv_type,currency,amount_from,amount_to,case_trans_from_dt,case_trans_to_date,
                        value_from_date,value_to_date,func_ind';


   sql_frmclause :=' FROM'||' '||'EI_SAV ';

dbms_output.put_line('the query is '||sql_slctclause||sql_frmclause);

 if ( payment_cen is not null ) then
      sql_whrclause:='WHERE'||' '||'payment_centre='||''''||payment_cen||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if;
   if (invsts is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'invstatus ='||''''||invsts||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (filename is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'searchname ='||''''||filename||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (acc_no is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'account_no ='||''''||acc_no||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (ent_typ is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'entry_type ='||''''||ent_typ||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (ref_typ is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'ref_type ='||''''||ref_typ||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (ref_no is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'ref_number ='||''''||ref_no||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (inv_typ is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'inv_type ='||''''||inv_typ||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (curr is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'currency ='||''''||curr||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if;
   if (amtfrm is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'amount_from ='||''''||amtfrm||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
end if ;
   if (amtto is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'amount_to ='||''''||amtto||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (case_txn_fdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'case_trans_from_dt ='||''''||case_txn_fdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if ;
   if (case_txn_tdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'case_trans_to_date ='||''''||case_txn_tdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;
   if (value_fdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'value_from_date ='||''''||value_fdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;
   if (value_tdt is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'value_to_date ='||''''||value_tdt||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;
   if (funcind is not null) then
     sql_whrclause:=sql_whrclause||' '||'AND'||' '||'func_ind ='||''''||funcind||'''';
dbms_output.put_line('sql_whrclause is '||sql_whrclause);
 end if;


  sql_query:=sql_slctclause||sql_frmclause||sql_whrclause;

  retrec := sql_query;
dbms_output.put_line('Entire Query is '||retrec);

  return ;

   OPEN advsrc FOR sql_query;

   /* FETCH advsrc INTO retrec;

    CLOSE advsrc;*/

End;  --}


==============================

Error

==============================

SQL> @scrpt_sam.sql
 10  /
RISI_ADV_SRCH_SAM('HK','121212','kasdjfkl','23121','asldfj','scb','JPY','1234','2345','10-DEC-2008','10-DEC-2008','10-DEC-2008','10-DEC-2008','sdfjlasjdl','sts','qwer','om','scbusr','scbcust','scbgrp',outpar);

ERROR at line 4:
ORA-06550: line 4, column 1:
PLS-00306: wrong number or types of arguments in call to 'RISI_ADV_SRCH_SAM'
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
Re: procedure execution [message #353638 is a reply to message #353631] Tue, 14 October 2008 07:45 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
And you continue to use poor programming skills. You ignore what cookiemonster told you. Numbers are not surrounded in quotes and '10-DEC-2008' is a character string, not a DATE. You are really having a tough time understanding database concepts, how are you going to understand TYPEs and REF_CURSORs?
Re: procedure execution [message #353642 is a reply to message #353098] Tue, 14 October 2008 07:56 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
You've followed one bit of advise - about the fetch/close - and ignored all the others.

Re-read what Frank, joy_division and I have written and go off and read the oracle documentation ref_cursors. It is on the internet you know.

When you've done all that and fixed up your code, if you're still having problems can please give us a copy and paste of ALL the code you are running.
That includes the stored procedure AND the contents of the script you are using to run it.
Re: procedure execution [message #353647 is a reply to message #353642] Tue, 14 October 2008 08:14 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
can you please give that documentation link
Re: procedure execution [message #353665 is a reply to message #353098] Tue, 14 October 2008 09:06 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try here:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/sqloperations.htm#LNPLS00605
Re: procedure execution [message #353760 is a reply to message #353647] Wed, 15 October 2008 00:49 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ORAGENASHOK wrote on Tue, 14 October 2008 15:14
can you please give that documentation link

Over a hundred posts. Merely impossible that you never got a reply pointing to the docs before.
Previous Topic: Updated rows count
Next Topic: Problem in database trigger
Goto Forum:
  


Current Time: Fri Dec 09 00:15:20 CST 2016

Total time taken to generate the page: 0.11721 seconds