You can use
db._connection # the raw cx_oracle connection
or
db._cursor # the raw cx_oracle cursor
as in
db._cursor.execute("your raw sql")
Mind that I believe cx_oracle does not like the terminating ";". You
need to try with and without that.
Massimo
On Nov 29, 1:48 am, Telman Yusupov <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
