|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pass parameter into script | alfredo | Shell Programming and Scripting | 2 | 04-08-2008 10:40 PM |
| how can i pass parameter with spaces to csh script | umen | Shell Programming and Scripting | 1 | 03-19-2008 12:33 PM |
| PASS parameter to AWK | unisam | UNIX for Dummies Questions & Answers | 2 | 05-14-2004 10:51 AM |
| Pass Parameter to Another Script | rvprod | UNIX for Dummies Questions & Answers | 4 | 04-05-2002 01:07 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
08-10-2006
|
||||
|
||||
|
Help required to pass the parameter
i am calling a pl/sql procedure through a shell script, there is one IN and 2 OUT parameter required to pass to the procedure to execute..
My procedure is XX_CITIDIRECT_EXP_PKG.main_proc and In parameter is p_period which I wanto to pass 'MAY-06'. Can anyone figure out, whats is wrong here HTML Code:
#!/bin/ksh
setenv TSTAMP1 "'MAY-06'"
sqlplus -silent apps/apps <<EOF
variable p_period varchar2
variable l_errbuf varchar2
variable l_errcode varchar2
execute XX_CITIDIRECT_EXP_PKG.main_proc(p_period =>$TSTAMP1,errbuf => :l_errbuf,retcode => :l_errcode);
exit;
EOF
|
|
08-10-2006
|
||||
|
||||
|
Help required to pass the parameter
then could you tell me then how the MAY-06 will be passed in present case
execute XX_CITIDIRECT_EXP_PKG.main_proc(p_period =>'MAY-06',errbuf => :l_errbuf,retcode => :l_errcode); but this is erroring out |
|
08-10-2006
|
|||||
|
|||||
|
Can you run in this way and make sure the same block is getting executed in sqlplus without error.If you get any error then paste it here. Code:
sqlplus -silent apps/apps <<EOF DECLARE p_period VARCHAR2; l_errbuf varchar2; l_errcode varchar2; BEGIN XX_CITIDIRECT_EXP_PKG.main_proc(p_period =>'MAY-06',errbuf => :l_errbuf,retcode => :l_errcode); END; / EXIT; EOF and passing parameter as unix variable add this statement in shell script x=`echo "'MAY-06'"` and when you call that procedure pass value as p_period =>'$x' Last edited by Dhruva; 08-10-2006 at 08:03 AM.. |
|
08-11-2006
|
||||
|
||||
|
#!/bin/ksh
TSTAMP1="'MAY-06'" <=== The problem is right here sqlplus -silent demo/demoyou12@ctrmad1 <<EOF variable p_period varchar2 variable l_errbuf varchar2 variable l_errcode varchar2 execute XX_CITIDIRECT_EXP_PKG.main_proc(p_period =>$TSTAMP1,errbuf => :l_errbuf,retcode => :l_errcode); exit; EOF |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
