Using Sqlplus to insert procedure names into a table

Question

Hi am using SQLPlus to develop an oracle database.The problem is that I intend to insert a procedure name into a table called available procedures. The problem is that once I write the name of the procedure to be inserted/updated it executes.Now, the procedure itself has a return which is an integer hence the reason for the error. How can I use SQLPlus to insert this procedure name?

Second, you should ask in a manner that give us an ideea of what happens in your code. You should give examples that make us able to reproduce your problem, etc. — Florin Ghita
– Florin Ghita, Commented Mar 14, 2012 at 12:17
This is strange: "once I write the name of the procedure to be inserted/updated it executes". You have a trigger? Procedures do not return anything, Funtions return something... — Florin Ghita
– Florin Ghita, Commented Mar 14, 2012 at 12:19

Tony Andrews · Accepted Answer · 2012-03-14 12:18:20Z

4

If you are trying to insert the name of a procedure, simply enclose it in single quotes:

insert into available_procedures (procedure_name) values ('MY_PROCEDURE');

and not:

insert into available_procedures (procedure_name) values (MY_PROCEDURE);

since this will (as you found) attempt to run MY_PROCEDURE

answered Mar 14, 2012 at 12:18

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user330315 Over a year ago

+1 for giving a sensible answer to an extremly unclear question

Florin Ghita Over a year ago

where my_procedure is a function :)

Collectives™ on Stack Overflow

Using Sqlplus to insert procedure names into a table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related