Asp and Oracle

Results 1 to 2 of 2

Thread: Asp and Oracle

  1. #1
    Rodolfo Guest

    Default Asp and Oracle

    My question is <BR>How can I execute a "view" in Oracle with asp ?<BR><BR>The following example work&#039s !!!!<BR>q="select * from TablaName"<BR>set oTemp=con.execute(q)<BR><BR>The following example dosen&#039t work !!!! because user_tab_columns <BR>is a view associated with schema objects.<BR><BR>q="select * from user_tab_columns"<BR>set oTemp=con.execute(q)<BR><BR>Can anyone help me ?<BR>Tanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Asp and Oracle

    Try adding the user.view name.<BR><BR>q="select * from user.user_tab_columns"<BR>set oTemp=con.execute(q)<BR><BR><BR><BR>HTH<BR><BR>Jer ry<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts