Solved

ORA-01008: not all variables bound

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Migrate Oracle Database from ASM to Non-ASM on a Windows server. 1 45
sort a spool into file output in oracle 1 30
grant user/role question 11 28
pl/sql - query very slow 26 61
Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

821 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