Solved

ORA-01008: not all variables bound

Posted on 2009-04-15
1
1,415 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 74

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

856 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