Re: DBMS

From: <marcpark_at_my-deja.com>
Date: 2000/05/03
Message-ID: <8epeli$3i8$1@nnrp1.deja.com>#1/1

Accept is a sql*plus command not a PL/SQL command. What you might do is accept the data before you start your declare block. MOve the data to bind variables.
Then put the data into your pl/sql table with the bind varaibles.

Marc Parkinson

In article <3908ADA6.E7EE9927_at_westat.com>, "Nick G. Anagnos" <anagnon_at_westat.com> wrote:
> Writing a plsql program to accept user inputs and want to move them to
a
> PLSQL table.
> Using the sqlplus command (accept) to capture the data.
> Moving the data one by one to a plsql table and using it as an single
> dimentional array.
>
> Problem: Trying to create loop to both capture the 6 separate input
> values and loop to store those values into a single dimentional
> array(plsql table), but having problems. Does anyone have any examples
> of something similar? Should I bag the accept command for something
> else. Is there a package or function that will fit my needs.
> Appreciate any advice.
>
> Nick
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 03 2000 - 00:00:00 CDT

Re: DBMS_?