Home » Infrastructure » Other Operating Systems » Pass parameter from Form to vms command file
Pass parameter from Form to vms command file [message #101746] Tue, 02 September 2003 07:58 Go to next message
Niamh
Messages: 7
Registered: June 2003
Junior Member
My command file runs a sql script that takes a paramter called p1 from the user:
!sqlplus username/password@database @filename 'p1'
The command file is called from a form but does not pass the value for p1:
Declare p1 number(3) := 100;
Begin
host('@filename p1');
End;
if I use :
host('@filename 100');
this works and passes the value of 100.
I am getting the error ORA-01722 Invalid number with the first syntax.
Any help appreciated.
TX
Re: Pass parameter from Form to vms command file [message #101760 is a reply to message #101746] Tue, 06 April 2004 12:36 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I guess you would have to have:
host('@filename '||p1);
Re: Pass parameter from Form to vms command file [message #101767 is a reply to message #101746] Fri, 30 July 2004 06:33 Go to previous message
Jason
Messages: 32
Registered: February 1999
Member
Instead of:
host('@filename p1');
Try:
host('@filename ' || p1);
Previous Topic: Wanted: an OS/390 Oracle DBA
Next Topic: Export from VMS
Goto Forum:
  


Current Time: Fri Mar 29 10:44:55 CDT 2024