Home » SQL & PL/SQL » SQL & PL/SQL » Automation Call procedure in SQLPlus to task it with Batch File
Automation Call procedure in SQLPlus to task it with Batch File [message #419613] Mon, 24 August 2009 08:22 Go to next message
webdino73
Messages: 15
Registered: August 2005
Junior Member
Hello,
I donĀ“t know how to write an sqlplus File which is then called from a batch file

1.question - what must I fill in to declare my variable the error is "ora-00363 1 cannot be used as an assignment target"
The variable to submit is p_korrekt. p_korrekt is an in out variable in the called stored procedure.

p_korrekt => :p_korrekt but how must I declare in an sql file to call in sqlplus or call sql File from Batch File?


my test file (test.sql):
content of test.sql
exec mview_work.interface_check_matv(1);
exit


my batch file:
sqlplus -s user/pass@ORCL @test.sql


Thanks for help.
Re: Automation Call procedure in SQLPlus to task it with Batch File [message #419624 is a reply to message #419613] Mon, 24 August 2009 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Instead of
exec mview_work.interface_check_matv(1);

Use
declare 
  something <sometype>;
begin
  mview_work.interface_check_matv(p_korrekt => something);
end;
/

Regards
Michel
Re: Automation Call procedure in SQLPlus to task it with Batch File [message #419648 is a reply to message #419624] Mon, 24 August 2009 14:02 Go to previous message
webdino73
Messages: 15
Registered: August 2005
Junior Member
thank you
Previous Topic: ORA-01460: unimplemented or unreasonable conversion requested
Next Topic: select from sql
Goto Forum:
  


Current Time: Mon Dec 05 19:32:02 CST 2016

Total time taken to generate the page: 0.05621 seconds