VB Crystal Report, SQL query: from SELECT statement to stored procedure with dynamic PL/SQL

SQL query: from SELECT statement to stored procedure with dynamic PL/SQL

Author	Message
Georges K #1 / 3	SQL query: from SELECT statement to stored procedure with dynamic PL/SQL Hello, I have about 30 reports that use a SELECT statement as SQL query and I would like now to use a stored procedure with dynamic PL/SQL (Oracle 7.3.3). I have an example of how to call a stored procedure, but I can't find a way to do it with dynamic PL/SQL inside: has someone any example? Also, when I try to change the SQL query from the SELECT statement to a call to the stored procedure, when I reopen the SQL query dialog box, it displays a new SELECT statement (not the original one): is it possible to switch from SELECT statement to stored procedure selection after the report has been created, or can it be chosen only at the creation of it? I haven't been able to modify a report from using SELECT to using a stored procedure... I use Crystal Reports 7. Thank you. Georges. -- Cycle 78, year 17 (Geng-Chen), month 7 (Jia-Shen), day 15 (Jia-Chen)
Fri, 31 Jan 2003 03:00:00 GMT

Peter Wallac #2 / 3	SQL query: from SELECT statement to stored procedure with dynamic PL/SQL PL/SQL cannot return a recordset like MS Sqlserver. It is impossible to use Oracle functions/procedures as a datasource to crystal, or at least it was when I checked into it last. Quote: > Hello, > I have about 30 reports that use a SELECT statement as SQL query > and I would like now to use a stored procedure with dynamic PL/SQL > (Oracle 7.3.3). I have an example of how to call a stored procedure, > but I can't find a way to do it with dynamic PL/SQL inside: has > someone any example? > Also, when I try to change the SQL query from the SELECT statement > to a call to the stored procedure, when I reopen the SQL query dialog > box, it displays a new SELECT statement (not the original one): is it > possible to switch from SELECT statement to stored procedure selection > after the report has been created, or can it be chosen only at the > creation of it? I haven't been able to modify a report from using > SELECT to using a stored procedure... > I use Crystal Reports 7. > Thank you. > Georges. > -- > Georges KO (Taipei, Taiwan) Quote: > Cycle 78, year 17 (Geng-Chen), month 7 (Jia-Shen), day 15 (Jia-Chen)
Sun, 02 Feb 2003 03:00:00 GMT

Georges K #3 / 3	SQL query: from SELECT statement to stored procedure with dynamic PL/SQL Quote: > PL/SQL cannot return a recordset like MS Sqlserver. It is impossible > to use Oracle functions/procedures as a datasource to crystal, or at > least it was when I checked into it last. It's actually possible by using an IN OUT REF CURSOR as one of the parameters of the procedure, then use OPEN passed_cursor FOR. Check Seagate Knowledge Base's article c2004898. So, how do I switch from a SELECT statement to a procedure in an existing report? I tried to modify the SQL query box, but it puts back a SELECT statement after I clicked on OK with a {myproc(?,?,?...)} inside the dialog. Also, when I refresh data, if I want to modify just ONE parameter and click on "Prompt for new parameter values", does it clean everything or just the chosen parameter ? Thank you.
Mon, 03 Feb 2003 09:51:44 GMT

Page 1 of 1

[ 3 post ]