Re: Unfunctioning Open for cursor PLS103

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 23 Jan 2006 08:16:46 -0500
Message-ID: <R5OdnS9-l6fcSkneRVn-qw@comcast.com>

"tosansu" <susanto.pitt_at_gmail.com> wrote in message news:1138008067.859935.160660_at_g14g2000cwa.googlegroups.com...
> My sqlplus seems to be unable to perform open for command! Anybody have
> an idea as why is this?
> :-) God bless
>

sql*plus does not perform SQL or PL/SQL, it sends it to the database

as sybrand indicated, you are likely attempting to issue a PL/SQL statement (to the database via SQL*Plus) outside of a PL/SQL block

post your code, error message, and database version for more specific help

meanwhile refer to the subject 'Opening a Cursor' at http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14261/sqloperations.htm (which can be found by doing a search for 'open cursor' at http://tahiti.oracle.com/)

++ mcs Received on Mon Jan 23 2006 - 07:16:46 CST