Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> doubt in sql
PROCEDURE show_temp
argument_name IN/OUT DEfault> ------------------------------------------------ p_name IN DEFAULT p_num IN DEFAULT
i want to show the procedure,but when i give
sql> @<procedurename>
it gives the error unable to open
the procedure <procedurename.sql> and
when i give like this
show procedure >procedurename>
it fives the error
"unknown SHOW option "procedure"
"unknown SHOW option "<procedurename">
please give a solution for this...
how do i open the procedure..
thanks in advance
ramola
Received on Wed Sep 05 2001 - 07:47:04 CDT