Hi,
I am working on a shell script that fires a plsql package. I would like the package to return a value to the shell script and then the shell script to return it to the javascript. Is it possible for the shell script to accept the return status from the plsql package and then pass it back... (4 Replies)
I am trying to send an email to personal id using plsql program. I have written a code in plsql using UTL_TCP package where opens the connections and then senda a mail. But when i execute the program mails are not being sent.
I typed "mail" command on the unix box and got the below result... (5 Replies)
Hi All,
i need you help while accessing the value from anonymous PL/SQL block.
Initially our requirement was to get the value from SQL statement. I was doing like...
But now i need to use dbms_application_info.set_module in it. So i have planned to use anonymous block instead of SQL... (2 Replies)
Hi All,
I have a requirement to mv a file in unix from plsql procedure.
for that i have created a java host procedure, a host_command, given all grants as per ORACLE-BASE - Oracle8i Shell Commands From PL/SQL
but i am getting an error ""Process err :/bin/sh: mv Not Found""
kindly let me... (1 Reply)
Hi all,
I need to pass a value from Unix to plsql block so that i can use the variable to in where caluse to get the desired output.
I tried useing $variable_name, but it doesn't work.
Any kind of help is appreciated.
Thanks in advance. (3 Replies)
##Execute the EDW_MEM_KEY_UPDATE procedure
ext_sta=`sqlplus -s ${Connstr} <<eof
set heading off;
set pagesize 0;
set feedback off;
set serveroutput on;
execute EDW_MEM_KEY_UPDATE ;
quit;
here`
vara="ORA-"
var=`echo $ext_sta | grep -c $vara `
Hi All,
above is a part of my unix... (7 Replies)
I previously worked for the L1 support on DNS/Apache servers in solaris10......
Now our team lead wants me to work on Oracle/plsql server for our new client....
I've to work without training...
How can we know that Oracle/plsql server running in our machine ??
How to Administrate... (1 Reply)
Hi,
I am using the below command to connect to a remote Oracle DB from my unix shell script.
sqlplus -s user1/password1@remotedbhost:1252/demo @/tmp/PROC_MS.prc
But I get the below error.
1. Can you confirm if my code is correct ?
2. Can you help me overcome the error ? (3 Replies)
Hi,I have a stored procedure to verify no of months since current fiscal.I want a shell script to exit with returtn code when the verification fails,I have shell script below but this doesnt work
sqlplus / << EOF
WHENEVER SQLERROR exit 1
WHENEVER OSERROR exit 2
DECLARE
v_time_period... (2 Replies)