Recent content by kthomas

  1. K

    10g instantclient

    I'm trying to get PL/SQL Developer and DOA to work with Oracle's new 10g "instantclient". I am able to connect with SQLPlus, but can't get PL/SQL Developer or DOA to work. With this "instantclient", there isn't any traditional Oracle Home defined in the registry. Any ideas?
  2. K

    LOBs in 10g

    Noticed that someone asked this question earlier. I don't have 5.1 though, will a fix be available for my version?
  3. K

    LOBs in 10g

    I've got PL/SQL Developer 5.0.0.474. I recently upgraded my database from 9i to 10g. Whenever I try to execute a stored procedure that uses LOB parameters, I get this error: "A TLOBLocator instance requires OCI8 mode, but OCI7 mode is used." Any ideas?
  4. K

    BLOB parameter

    I'm using 5.0.0.474. I'm trying to test a stored procedure that has a BLOB input parameter. However, when I try to test it in PL/SQL developer, it won't let me set the value for the BLOB by importing a file (the import button is grayed out). The import function works elsewhere-- for example...
  5. K

    ShowDOAInfo

    It's not documented as far as I know. Just call it & it'll bring up a messagebox...
  6. K

    ShowDOAInfo

    I'm aware of your ShowDOAInfo procedure which gives a bunch of DOA information in a dialog box. Are there functions available to query individual ShowDOAInfo items? My objective is this: I've got an about box in an app which lists version numbers for several components and would like to list...
  7. K

    LOBs

    I'm issuing a select statement against a table w/ a CLOB and BLOB field & am getting this error: "A query w/ LOBs requires NET8, which is not detected on this PC." To my knowledge, I have NET8 installed. I checked the Oracle installer which shows "NET8 client 8.0.5.0.0" and "OCI 8.0.5.2.0"...
  8. K

    Date input parameter

    For this procedure call: spMobileX.CallProcedure('MILEAGE_ACC', ['PAREA',edtArea.Text, 'PSTART_DATE',dtpStart.Date, 'PEND_DATE',dtpEnd.Date]) ; I get a "PLS-00306: Wrong number or types of arguments in call to MILEAGE_ACC". The parameters are correct (input...
Back
Top