Oracle Error 1008

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
Who is Participating?
poncejuaConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.