HELP! HELP! HELP!

From: STI News <habloche_at_sti.com.br>
Date: Thu, 17 Jun 1999 13:30:23 -0300
Message-ID: <7kb7i6$p1u$1@news.sti.com.br>

I need to use FUNCTIONS (ORACLE) on Visual Basic 3. I use snaphot executing PL/SQL on my code:

  Dim oDB      As Database
  Dim oDS      As SnapShot

  Dim SSQL As String

  Const Db_SQLPassThrough = 64

  Set oDB = OpenDatabase("", False, False, "ODBC;DSN=ORATEST;...")

  SSQL = "SELECT fniq03040('005','DAC',null,'0028584','NFF','UN','00023217') FROM DUAL"   Set oDS = oDB.CreateSnapshot(sSQL, Db_SQLPassThrough)

  MsgBox IIf(IsNull(oDS.FIELDS(0)), "", oDS.FIELDS(0))

  ODS.Close

  FNIQ03040 is USER FUNCTION and return message but update tables.

  The error message is:

  ORA-06571: Function FNIQ02040 does not guarantee not to update database

   HELP-ME! Received on Thu Jun 17 1999 - 11:30:23 CDT