CODEWITHSUNDEEP
oracle-databaseplsqltoad
Ahsan Ali
Ahsan Ali

Reputation: 139

Remove unidentified Bind variable in Toad popup window using oracle

I am trying to create a package in Oracle, whenever I try and execute it as a script, the following popup appears whereas I have not added any bind variable in my package code.

How can I identify where this popup is arising from in my package.

enter image description here

Upvotes: 0

Views: 469

Answers (2)

Ahsan Ali
Ahsan Ali

Reputation: 139

The problem was that even if you write in a comment as "& IBF" in my case, Toad will ignore the space and consider it as a bind variable.

Make sure to search the string "IBF" instead of &IBF as in my case the editor did not return any results for "&IBF"

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142715

Did you search the package for &IBF? That should be your first move.

Then, as you use TOAD, open its Options and navigate to "Editor - Execute/Compile" section which contains the "Substitution variable prompting" whose options are:

  • all
  • ignore those in comments --> I'd say this might be what you need to se
  • none

Or, if you created the package in SQL*Plus, before running the CREATE PACKAGE command, set define off.

Upvotes: 1

Related Questions