Search Results

i wanna

funciton A (p1 number)
{
return v2,
}

MM()
{
somehow call the function A and use the return value;

}

who can show me how to call pl/sql function or precudure in unix script..

cheers,

Thanks, I will check it tomorrow.

set pagesize 0

Now my task is
there are two servers A and B.
i only can put unix script in server A and database is on server B.

can I write a script in serer A which could telnet to server B and run the...

excellent.

You r my hero.

many thanks

doesnt work.

new problem comes out..

unix script calls sql script and save the output into a file. but now there are many empty lines in the output file.

first line is empty and follow by 13 rows of data...

oh..yeah.

i got

.
/
after query.:P

by the way, the first line is empty how can i delete it.

it looks like printout twice. does it because select twice?
however I have tried another query and just format it in the select statement, it printed the result twice as well.

I did use mine before u mentioned that so i think it is not the reason

I tried. but it printed out the result twice.

Thanks anyway

nah..cos i got a cursor outside this code.

actually our code structure are exactly same but mine one still doesnt work

i tried but same error msg.

it said encounter Case and expecting some symbols as +,_....

what does trimspool on mean

the original query looks like:

select /*+ ordered index (a fk_event_hist_1) */
trunc(start_dtg) as tran_date
, a.event_code
, b.event_desc
, sum(case when error_text like...

I have rewritten the query and made it work. but i still got another 3 querys.

any other way to escape the keyword case in the sql query so that I dont need rewrite them?

many thanks for your help. i have sorted out. silly mistake.
cheers.

I had thought probably I mistyped something,however, I checked it again and again, the answer is no.

is it possible to cause this problem because of the system?

one more difference is i got...

but why I added that line and it still doesnt work.

gonna go home now and wil be back online in a hour, maybe half.
Thanks for your help.
cheers

i tried,no change. however I think as I save the output in a file so it doesnt matter whether I set serveroutput on or not. not sure right.

I couldnt send email to you. so i just put the script here

timeout(){
`$ORACLE_BIN/sqlplus -s $user/$passwd << EOM >output.csv
set verify off
set heading off
set feedback off
declare
cursor...

can I email you my unix script, quite long though