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

Email to a friend script problems
I have this send-to-a-friend script with 2 issues:


1) When you open the form popup on a p

TCP Sending Unsigned Char...
Hi...

I want to send over tcp/ip some data, i have the data in hexadecimal, and when i tr

finding key position of specified value in multi-dimensional array
Code: $openedfile = fopen($tfc_file4, "r");
$rc = 1;
while(!feof($openedfile))
{<

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: [Select]blog:edit_all,delete_all|users:edit_all

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

email CODING Problem
Email coding problem.

I need to send a section of the info to $tf and the same as a Cc to $em