Solved

ORA-01008: not all variables bound

Posted on 2009-04-15
1
1,411 Views
Last Modified: 2013-12-18
In Toad I am trying to execute an stored procedure which return an out variable O_RetMessage.
But when I try to execute the code I get error message as:
ORA-01008: not all variables bound
DECLARE  

    I_SerialNo NVARCHAR2;

    I_Status NUMBER;

    I_WONUMBER NVARCHAR2;

    I_EngineBuildProperty NUMBER;

    I_WorkStation NVARCHAR2;

    I_EmployeeNumber NVARCHAR2;

    O_RetMessage  NVARCHAR2;

    BEGIN 

    I_SerialNo :='1';

    I_Status  :='2';

    I_WONUMBER  :='3';

    I_EngineBuildProperty  :='4';

    I_WorkStation  :='5';

    I_EmployeeNumber  :='6';

    O_RetMessage :='7';

     --BEGIN

       execute immediate  MYSP(I_SerialNo,I_Status,I_WONUMBER,I_EngineBuildProperty,I_WorkStation,I_EmployeeNumber,O_RetMessage);

      --END;

      DBMS_OUTPUT.PUT_LINE('oRetMessage: ' || :O_RetMessage);
 

    END ;

Open in new window

0
Comment
Question by:thermalsun
1 Comment
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 24148271
remove the :  on :O_RetMessage


DBMS_OUTPUT.PUT_LINE('oRetMessage: ' || O_RetMessage);
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now