am I using this for loop correctly

Posted on 16th Feb 2014 07:03 pm by admin

Dear buddies!

Right now I am generating a report with some details for all the dealers.

I am required to separate the report for each dealer respectively in separate reports. I tried this method and its not of help.

Please advice.

procedure convert_excel IS dealer_name varchar2(100); begin -- Test statements here for dealer_name in (select dealer_long_name from tbl_dealers) loop print_report( 'select dealer_region as "Dealer Region", dealer_long_name as "Dealer Name", "# of Received" as "#of Customer Received", "#of Converted", "%of Conversion" , from dealer_performance t where dealer_name = t.dealer_long_name', 'dealer_performance||dealer_name||.xml','Y'); end loop;

I didn't receive any compilation error. Compilation is successful.

I received an error when I was executing.

ORA-00904: "DEALER_NAME": invalid identifier

Please advice, where I am making the mistake.

Thanks.

Your Answer:

Login to answer

Other forums

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

Parse error: syntax error, unexpected T_ELSEIF in /home/......html/item.php on l
I do not know what is wrong with this. Hope some one can help. I do nto want to post the entire site

PHP MySQL Return Results Issue
Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have a

Need a fuction to count entries in a field
Hi
I need a fuction to count how many times a email address is entered in to a field.

I ma

Why does my crawler script suddenly end with no error?
Hi.

I have written a web crawler script. It will visit a large number of URL's with cURL.

C problem struct and string
Hi guys,

This is my first post and I'm hoping the experts here can help me solve my problem.<

Cron Job and Output
I have php codes running under a cron job.
But everytime i output (echo) , it comes out as comple

Text file to .Dat file Conversion in PHP
Hi All,
Could anybody provide code for Text file to .Dat file Conversion in PHP.

Tha

php automatically escaping single quotes
I'm trying to test out my security a bit and I've noticed that php is escaping my single quotes. For