DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help on Pro*C

  1. #1
    Join Date
    Sep 2005

    Help on Pro*C

    Environment: WINDOWS, AIX, oracle 9i, pro*C Release

    Objective: in Pro*C Get the full query when there is an SQLERROR

    Actually, we get the statement of the PC Class with the method SQLStmtGetText()

    But the statement have this form :

    ‘select serr_code ,serr_excp ,serr_type_mess ,mess_iden ,serr_enrg ,rowid into :b0:b1,:b2:b3,:b4:b5,:b6:b7,:b8:b9,:b10 from SERR where SERR_CODE=:b11’

    then we are trying to replace :b0…. By its values using sqlstm.sqhstv (for data) and sqlstm.sqhstl (for the size of data)

    but if we have an varchar which have the same size than an integer or a double then we convert it as an integer or a double.


    1/ is there any structure, or method which help us to know if the data in sqhstv is a character or a number ?

    2/ is there any method, like SQLStmtGetText(), which send back the full query with the :b0…replaced ?


  2. #2
    Join Date
    Jan 2001

    The Pro *C development guide has an example of sqlgls function which returns the most recent sql statement executed.


Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.