Re: DBMS_?

"Nick G. Anagnos" 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

I consider this to be trickery, but I've used it successfully on a Unixware 2.1.2 system with Oracle 7.3.4.

You'll have to first do a utl_file.fopen('/dev/stdin','r') to open standard into for reading and then loop through and read your six inputs with utl_file.get_line. Received on Wed May 03 2000 - 00:00:00 CDT