Jump to content
Changes to the Jaspersoft community edition download ×

Oracle stored procedures problem


2005 IR Help

Recommended Posts

By: nexus - ricardo63

Oracle stored procedures problem

2004-04-16 09:25

As I can execute a stored procedure Oracle that returns resultset of refcursor type? . Or a stored procedure and later a SELECT to bring the data, at the moment I am using (Ireport) :

 

{call WRP_PRUEBA1('RICARDO','ultima')}

select * from aud_logproceso order by proceso

 

the following error takes place :

 

ORA-6550 line 2 , column1

PLS-00103 encountered the symbol "SELECT"

ORA-6550 line 2 , column 45

PLS-00103 encountered the symbol "end-of-file"

 

and when proving :

 

begin

WRP_PRUEBA1('RICARDO','prueba');

select * from aud_logproceso order by proceso;

end;

 

ORA-6550 line 3 , column 1

PLS-00428 an INTO clause is expected in this SELECT statement

ORA-6550 line 3 , column 1

PL/SQL SQL statement ignored

 

as I can obtain that this works? . It would thank for much any aid on the matter .

 

Thanks

 

Ricardo

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...