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 :




select * from aud_logproceso order by proceso;



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 .





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...