Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Problem with stored procedure Post Reply Post New Topic
Author Message
alarpross
Newbie
Newbie


Joined: 09 May 2008
Location: Colombia
Online Status: Offline
Posts: 3
Quote alarpross Replybullet Topic: Problem with stored procedure
    Posted: 09 May 2008 at 8:54am
Good, I'm trying to make a report in Crystal reports 10 and I need to add a report stored procedure but asks me to try to add some parameters of entry and when I give parameters or to allow zero the fields generates an error which reads: 'HY000:[Oracle][ODBC][Ora]ORA-06550: line 1, column 7: PLS-00221: 'VENCIMIENTO' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
So How Can I enter these Stored Procedures for generating reports?
Thank you
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 12 May 2008 at 4:23am
Where are you adding the stored procedure?  It does need to actually be created in the database (say, by a DBA).  You can't simply create it in the report.
IP IP Logged
tpc2884
Newbie
Newbie
Avatar

Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 6
Quote tpc2884 Replybullet Posted: 14 May 2008 at 6:51am
i have added a column to a store procedure now i need to add that column to my crystal report. I do not want to drop the procedure to readd the column what is the best way to add the column.
IP IP Logged
tpc2884
Newbie
Newbie
Avatar

Joined: 13 May 2008
Location: United States
Online Status: Offline
Posts: 6
Quote tpc2884 Replybullet Posted: 14 May 2008 at 6:56am
how do you add a field to crystal reports
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 14 May 2008 at 10:00am
Originally posted by tpc2884

i have added a column to a store procedure now i need to add that column to my crystal report. I do not want to drop the procedure to readd the column what is the best way to add the column.



First, a note on forum etiquette.  Please create your own topics (using the "new topic" button near the top of the screen) and title them appropriately.  This helps other users who may have similar questions.

To update Crystal in this way, go into the Database menu and select Set Datasource Location.  With this dialog, you can tell Crystal to update its record of what your query looks like (i.e., Crystal can realize that you've added a column).


IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 14 May 2008 at 10:00am
Originally posted by tpc2884

how do you add a field to crystal reports


Is this the same as your earlier question, or is this a separate question?


IP IP Logged
alarpross
Newbie
Newbie


Joined: 09 May 2008
Location: Colombia
Online Status: Offline
Posts: 3
Quote alarpross Replybullet Posted: 14 May 2008 at 12:40pm
I try to update my Stored Procedure of this form... I have to choose the table where I need the Stored Procedure and I created my report BUT  when I try to run it isn't possible and show off a fail that say:
"Failed to open a rowset."
Details: 'HY000:[Oracle][ODBC][Ora]ORA-06550: line 1, column 7: PLS-00221: 'VENCIMIENTO' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
I think that the problem is with ODBC Connection but I'm not sure and I don't have other form to connect to this DB... 
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 15 May 2008 at 5:17am
OK, a couple of troubleshooting steps.

Can you run this stored proc inside Oracle?  Does it return records?

Can you create a new, blank report that uses this stored proc as a data source?

Are you using the native Oracle ODBC, or something like JDBC to make the connection?  If you aren't using the Oracle driver, then there may be a proprietary bit in the procedure that can't be processed by the driver you are using.


IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.