Search results for query: *

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 ...

Many Thanks for you help.

Many Thanks. What if I just want to extract the first three parameters? Actually in that case your script displays 3=last name,1000. Regards Ajay.

Hi, My requirement is to get the arguments for a stored proc from a .csv file. Only problem in getting the arguments is the spaces in between the values.e.g.the file is like 123,first name,last name,1000 arg1=123 arg2=first name arg3=last name arg4=1000. Any help on this would be appreciated...

Hi, You'll have to use sub-query in the update stmnt, update table1 a set a.onhand = ( select b.onhand from table2 b where a.field1 = b.field1 and a.field2 = b.field2 and a.field3 = b.field3 ) Assuming that table1...

Try this one : for i in `cat 1.txt|tr -s ' ' '~'|cut -d' ' -f1-2` do field1=`echo $i|cut -d'~' -f1` field2=`echo $i|cut -d'~' -f2` if [ $field2 -eq 0 ]; then echo &quot;$field1 has a count of zero&quot; >> tempfile fi done mailx -s &quot;Subject of mail&quot; mailid < tempfile rm tempfile...