Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute a View with sp_columns

154983Feb 5 2002

Hi

The following two line were using SQL server 2000 I would like to know what would be the equivalent code in oracle

SqlQuery = "sp_columns CONT_Full_Search_View"
Set RS = Conn.Execute( SqlQuery )

when I run this code I get this error message

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

/Gels_ssqc_application/global.asa, line 386

I think it has to do with the sp_columns ..

can anyone help

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2002

Added on Feb 5 2002

#database-and-application-migrations

1 comment

1,287 views