[Tutor] How can I execute a PL/SQL Procedure directly through

[Amit Saxena]

It is a complete PL/SQL Cursor which is written in this "metadata.sql" file

On 7/30/07, Greg Lindstrom <gslindstrom at gmail.com> wrote:
>
>
>
> On 7/30/07, Amit Saxena <amitsaxena69 at gmail.com> wrote:
> >
> >
> > I m still not able to run a Procedure
> >
> > from cx_Oracle import makedsn
> > import adodb
> >
> > db = adodb.NewADOConnection('oci8')
> > connection_string = makedsn(" 10.200.91.27 ", 1521, "scorpio")   #<==
> > your values here, of course
> > db.Connect(connection_string, "kcmdev", "devkcm")  #<== and here, too
> >
> > #query = "SELECT * from USER_ROLE where ROLE_FK = 29"
> > results = db.Execute("metadata.sql")
> > print results
> >
> >
> > is giving an error saying
> >
> > Traceback (most recent call last):
> >   File "D:/Python/sql.py", line 9, in <module>
> >     results = db.Execute("metadata.sql")
> >   File "C:\Python25\Lib\site-packages\adodb\adodb.py", line 274, in
> > Execute
> >     c = self._query(sql,params)
> >   File "C:\Python25\Lib\site-packages\adodb\adodb.py", line 265, in
> > _query
> >     raise sys.exc_info()[0] ,str(err)+': '+sql
> > DatabaseError: ORA-00900: invalid SQL statement
> > : metadata.sql
> >
>
> What is in metadata.sql?  If it is a PL/SQL query, then you should "SELECT
> metadata()".  If is a file containing sql (is the pl/sql you wish to execute
> in this file?) then I'm not sure how to proceed.
>
> Is the PL/SQL you wish to run saved in Oracle?  Can you show us what's in
> the metadata.sql file?
>
> --greg
>



-- 
Thanks and Regards,
Amit Saxena
Senior QA Engineer
Ketera
Direct: +91 4199 5028
Mobile: +91 99001 18641
asaxena at ketera.com

» Visit us at http://www.ketera.com
» Watch the demo at http://www.ketera.com/resources/demos.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20070730/d3a30f34/attachment-0001.html