Home » Developer & Programmer » Forms » Passing parameter from Forms 4.5 to vms command file
Passing parameter from Forms 4.5 to vms command file [message #83277] Tue, 02 September 2003 05:23
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

Report message to a moderator

Previous Topic: Forms Triggers' and plsql Listing
Next Topic: Problem -- OracleForms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 24 23:42:26 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.