Help on Pro*C
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help on Pro*C

  1. #1
    Join Date
    Sep 2005
    Posts
    1

    Help on Pro*C

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



    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.



    Questions:

    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 ?



    thanks

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

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

    regards
    Hrishy

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