Recent content by ajayarora

where to_char (PLAN.YEARENDDATE, 'YYYY' ) = '2002'

It is due to your outer cursor, you need to open and close your outer cursor at a certain commit frequency ( after processing 5000 records may be ).If you can post the structure of your procedure then I would be able to make it more clear to you. Regards

Hi, Does "others" have write permissions to the directory mentioned ? Regards Ajay.

Hi, a) To search the table names , you can query all_dependencies table and b) To search for a particular column you should query all_source table like select name,text from all_source where text like '%column_name%'. I hope it helps. Regards

Hi Sajjum, The command line to call a stored proc from unix shell is : sqlplus -s <<!>${TMPFILE} ${UID_PASSWD} set tab off head off echo off feed off pages 0 serverout on size 1000000 linesize ${MAX_LINES_SIZE} wrap off verify off trimspool on whenever SQLerror exit 10 whenever OSerror exit...

Its working now...thanks for your help. Regards Ajay.

Thanks for your help. Don't we have something like -f2- in awk. Actually, the first field in the original file is a file-id and on the basis of which I've to create a file. like 1~2~3~4 will result in a file say abc containing 2~3~4 and 2~x~y~z will go to another file say pqr containing x~y~z ...

Hi, I've a file with fields sperated by ~, like 1~2~3~4 1~x~y~z My requirement is remove the first field and create another file rest of the fields like 2~3~4 x~y~z I don't want to use &quot;cut&quot; command as it would be slow as compare to awk script. Any help would be appreciated. Thanks.

Try using following set statement as well : set trims on Regards Ajay.

Yes, but you can't schedule stored procedures directly thru Autosys.You'll have to write a wrapper unix script to call the stored proc and that unix script can be schedule thru Autosys. Regards Ajay.

Hi Sampsonr, I'm sending two single quotes using sed like my_argument=`echo $my_argument | sed &quot;s/'/\'\'/g&quot;` Its working fine now. Thanks for your suggestion and time. Regards Ajay.

Is it possible to pass unix arrays as parameters to a PL/SQL procedure. If anyone knows about this then please let me know. Regards Ajay.

Thanks for your reply. I'll try to implement this.

Hi, A stored proc is being called thru a unix and therefore the parameters to the procedure are enclosed in single quotes.But whenever a parameter containing single quote in its value is passed to the proc, the procedure fails with the error message : 'quoted string not properly terminated'...

Hi, I'm calling a PL/SQL procedure from a unix shell script. Shell gets its params from a file and passes them (enclosing the params in single quotes) to PL/SQL.It works fine for most of the cases but whenever a parameter contains single quote(') in it, procedure fails with the error message ...