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

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi

Taylor Series Function
So I am working a a project for my intro C++ class, and I am having some trouble with a function for

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do