sqlforms30 probems/questions

I have two problems(besides typing too fast) 1. in sqlforms30, I use a host command that is triggered when next-block  is keyed. The command follows
HOST('sqlplus userid/password_at_T:hostmachine:database @script' ||:student_id,NO_screen);

the script contains the following:

 insert into temp(var) select var from table1 minus select var from   table2 where student_id = '&1');

student_id is a character and forms passes the text but not in quotes.
*
*now for this script. It will run with the proper results on the sql
 command line (the sql statement) and when I run the script(_at_script) BUT when I run the form It gives me a SQLPLUS:command not found. ANYONE Have any Ideas.

Now for the second problem.
I have 2 time fields -- Time1,Time2. The values we inserted through forms with their field declared time in the forms and number in table creation . Query works find but when I use a list of values I get the number

and when I try select to_char(time1,'HH24:MI') time1 (or even without the colon and using all other variations of HH24MI)from table I get a invalid character format. Any suggestions???

If anyone has any answers to these problems please email me at mellott_at_db.erau.edu
I thank you in advance for your time and cooperation. Received on Wed Nov 25 1992 - 17:28:11 CET