| Pass parameter from Form to vms command file [message #101746] |
Tue, 02 September 2003 07:58  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
