Recent content by mridley

  1. M

    SQL bind variable find and replace

    OK. Thanks Marco. Didn't think DOA did this but just thought I would check anyway. Congratulations on a very nice component anyway - very easy to use.
  2. M

    SQL bind variable find and replace

    Sorry Marco: We Can currently use the FindVariables function to return a list of bind variables in a SQL statement. What if a user wants you to supply potential values for the bind variables in a SQL statement? You have to know at least what column in the SQL statement each bind variable refers...
  3. M

    SQL bind variable find and replace

    Is there any way to know which table.column a found bind variable belongs to - so I can then replace a found bind variable with a correct literal value in the actual SQL statement?
  4. M

    Logging on as sysdba

    RE: SQLPLUS way will work - just have to supply connection string in double quotes to stop dos chopping off at the space: sqlplus "sys/ as sysdba"
  5. M

    Logging on as sysdba

    Upon actually trying out the SQLPLUS from DOS way, found that cannot connect 'as SYSDBA' from DOS. Probably makes sense from a security standpoint.
  6. M

    Logging on as sysdba

    To get SYS grants, for a windows based App, try this: - Have all your grants in a .SQL file. - In Delphi code, Open up SQLPLUS in DOS, connecting as 'sysusername/syspassword@db as sysdba', then get SQLPUS to run the .SQL file with your grants.
  7. M

    DOA 3.3.1 and missing OCI.dll issue

    have a client encountering issues with the DOA. The application uses Oracle 7.3 and above, and the executable was made using Delphi 5, DOA version 3.3.1, and Net8. The following error was encountered: 'Initialization error Could not find OCI.dll OracleHomeKey: SOFTWARE\ORACLE\HOME1...
See more
Back
Top