output parameters in stored procedure [message #414] |
Mon, 11 February 2002 07:06 |
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
|
|
|
|
|
|