Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Oracle Error 1008

Posted on 1998-07-01
1
Medium Priority
?
2,080 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
1 Comment
 
LVL 3

Accepted Solution

by:
poncejua earned 200 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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month13 days, 9 hours left to enroll

580 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