Solved

ORA-01008: not all variables bound

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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
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 syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

679 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