Home » SQL & PL/SQL » SQL & PL/SQL » output parameters in stored procedure
output parameters in stored procedure [message #414] Mon, 11 February 2002 07:06 Go to next message
LI810
Messages: 25
Registered: February 2002
Junior Member
Please help:

here is the fragment from my stored procedure
------------------------------------
CREATE OR REPLACE PROCEDURE DEVELOPER.test1
(c1_in IN varchar2,rec_out out temp_current3%ROWTYPE)
--(c1_out OUT types.cursortype)

as

v_table varchar2(50);
v_table_out varchar2(50);
v_rowcount number(12);
v_rowcount_out number(12);
v_diff number(12);
sql_stmt varchar2(200);

cursor c1 is
select TBL_NME_X,avg(row_count)*1.1 as row_count
from TABLE_REC_AUDIT
group by tbl_nme_x;

--------------------------------------------
It compiled without errors. When I try to executed I got this error message .
Any help is appresiated.

Error: ORA-06550: line 3, column 15:
PLS-00103: Encountered the symbol "." when expecting one of the following:

constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar
The symbol "exception was inserted before "." to continue., Batch 1 Line 3 Col 15
Re: output parameters in stored procedure [message #416 is a reply to message #414] Mon, 11 February 2002 07:18 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

rec_out is of type temp_current3%ROWTYPE.so can u make sure , u r invoking the procedure correctly

cheers
pratap
Re: output parameters in stored procedure [message #418 is a reply to message #416] Mon, 11 February 2002 07:36 Go to previous messageGo to next message
LI810
Messages: 25
Registered: February 2002
Junior Member
What do you mean ? Please clarify
Table temp_current3 exists .
Otherwise , it is my question what is wrong with the syntaxis.

thank you.
Re: output parameters in stored procedure [message #420 is a reply to message #418] Mon, 11 February 2002 07:47 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
what syntax u r using to call that procedure?
Previous Topic: how do i store the value 123.50 as it is in oracle
Next Topic: How to execute a procedure
Goto Forum:
  


Current Time: Mon Aug 03 05:07:52 CDT 2020