PL/SQL (MOSC)

MOSC Banner

pl/sql code error

edited Sep 30, 2013 8:31AM in PL/SQL (MOSC) 4 commentsAnswered
Hi,

the below pl/sql procedure showing below error.  


show errors;

Error starting at line 49 in command:
DECLARE
result_str VARCHAR2(1000);
BEGIN
get_result1(1083,631492,result_str);
dbms_output.put_line(result_str);
END;
Error report:
ORA-06550: line 4, column 1:
PLS-00905: object GET_RESULT1 is invalid
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:
 
===========================procedure code==============
 
 
CREATE or replace PROCEDURE get_result1
    ( p_option_type_id  IN NUMBER
    , p_serial_no     IN NUMBER
    , p_result      OUT VARCHAR2
    )
AS
cursor c1 is SELECT DISTINCT CHILD_ID FROM V_OPTION_GROUP_MAP WHERE OPTION_ID = p_option_type_id;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center