Bruce and others castors:
I'm not neither a database expert nor an oracle guru, so I have to talk about what my co-workers said. There are a lot of business logic on the database. Bad point, of course, but cannot be changed now.
They told me there are functions and stored procedures in databases. Function returns values that must be assigned to a variable, as a part of a code. Function can make updates, but in this case cannot be done inside a select, because it may produce an inconsistency. If a function must be called, it have to be done in script mode. Inside programs, it means to call it with a callable statement, not as a prepared statement. And that's what I have to do somehow.
As you can see, it is more complex than a stored procedure. I don't know if there is a solution now, which could be wonderful. If it's not I leave it for the future.
Thanks.
-----Mensaje original-----
De: Bruce Snyder [mailto:[EMAIL PROTECTED]]
Enviado el: Friday, January 24, 2003 21:08
Para: [EMAIL PROTECTED]
Asunto: Re: [castor-dev] Functions supported?
This one time, at band camp, Gustavo Pistoia said:
GP> I need to call a function of my oracle database (tipically with
GP>CallableStatement)
GP> Do I have any chance to do it?
GP> I wrote: CALL DVB('12345') AS gen.MyObject but it didn't work.
GP>
GP> Thanks you!!!, I have spent some hours with that.
Gus,
If you're referring to calling a stored procedure, Castor can do that. See the end of the section in the following document:
http://www.castor.org/jdo.html#OQLQuery
If stored procedures is not what you're referring to, please explain further.
HTH.
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
