Solved

Oracle Error 1008

Posted on 1998-07-01
1
1,981 Views
Last Modified: 2008-02-01
When I run a PL/SQL script I get
ORA-01008 not all variables bound.
When I check all host variables using Print they have values.
What is causing the error.
Digital UNIX 4.0D
Oracle 7.3.4
Pl/SQL 2.3.4
SQL*Plus 3.3.4
0
Comment
Question by:rdoggart
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
poncejua earned 100 total points
ID: 1083232
This error usually occurs when you reference a bind variable in other than a PL/SQL statement, such as a SQL statement, containing substitution variables that was executed without all variables bound.  All substitution variables must have a substituted value before the SQL statement is executed.  In OCI, use an OBIND or OBINDN call to substitute the required values.

Bind variable can only be referenced in PL/SQL. You cannot use it in SQL*Plus commands. Note that bind variable can be used in EXECUTE command which runs one PL/SQL
statement.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create table from select - oracle 6 68
Repeat query 13 74
Problem with duplicate records in Oracle query 16 52
setting local variables in a cursor block 3 30
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup

726 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