Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> doubt in sql

doubt in sql

From: Ramola <j_ramola_at_yahoo.co.uk>
Date: 5 Sep 2001 05:47:04 -0700
Message-ID: <65c40e25.0109050447.6f7259b0@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US