Oracle Run Procedure with one in parameter and multiple out parameter
ORA-06550: line 2, column 2: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
I get this error:
ORA-06550: line 8, column 4: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin case declare end exception exit for goto if loop mod null pragma raise return select update while with an identifier a double-quoted 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error. *Action: PL/SQL procedure successfully completed.
I'm really not sure how to change my call to the procedure to make it work with SQL Developer. Any help would be greatly appreciated.
Declare
x VARCHAR2(30);
y VARCHAR2(30);
z VARCHAR2(40);
Begin
GET_EMPLOYEE(1, x, y, z);
DBMS_OUTPUT.PUT_LINE(x);
End;
Or an another version of stub execution.
var x varchar2(30);
var y varchar2(30);
var z varchar2(40);
exec GET_EMPLOYEE(1, :x, :y, :z);
ORA-06550: line 2, column 2: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
I get this error:
ORA-06550: line 8, column 4: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin case declare end exception exit for goto if loop mod null pragma raise return select update while with an identifier a double-quoted 06550. 00000 - "line %s, column %s:\n%s" *Cause: Usually a PL/SQL compilation error. *Action: PL/SQL procedure successfully completed.
I'm really not sure how to change my call to the procedure to make it work with SQL Developer. Any help would be greatly appreciated.
Declare
x VARCHAR2(30);
y VARCHAR2(30);
z VARCHAR2(40);
Begin
GET_EMPLOYEE(1, x, y, z);
DBMS_OUTPUT.PUT_LINE(x);
End;
Or an another version of stub execution.
var x varchar2(30);
var y varchar2(30);
var z varchar2(40);
exec GET_EMPLOYEE(1, :x, :y, :z);
No comments:
Post a Comment