Hi everyone,
I'm developing a web2py application on top of a legacy Oracle database
and need to call some existing stored procedures that mplement some
complex transactional computations that would be impractical to
perform in application layer.
I have cx-oracle driver installed and properly working - DAL works
fine for straightforward web2py ORM activities.
cx-oracle implements callproc function for these purposes.
Unfortunately, I'm new to Python and wasn't able to modify sql.py in
gluon package to add it to DAL.
So, instead, I'm trying to use executesql method in my controller
trying to pass an anonymous PL/SQL block, as in this example:
db.executesql('begin my_proc_name(arg1, arg2); end;')
Unfortunately, I keep getting errors like the one below. I think I've
tried every possible combination but none of them work.
DatabaseError: ORA-06550: line 1, column 26:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of
the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue
Can you please advise what would be the best option here? Any
suggestions will be very much appreciated!
Thanks a lot in advance,
Telman
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
