Very Computer

1. Using SQL-call in PDM SQL ODBC plugin

Has anyone out there successfully called a stored procedure in a SQL
database using PDM's ODBC plugin?

I put together a simple test stored procedure in Oracle that looks like
this:

    CREATE OR REPLACE PROCEDURE FMPTest (
        strTest  OUT    VARCHAR2
    ) IS
    BEGIN
        strTest := 'My test string';
    END FMPTest;
    /

We tried to call it like this from FMP using something like this:

    SetField [_gSQLstatus, External ("SQL-call", "FMPTest")]

We got an error message that said the following in the results field:

    WARNING: [ORACLE][ODBC][Ora]ORA-00900: invalid SQL statement.

Has anyone gotten this sort of thing to work?

If so, do you know how to get IN parameters passed to the stored
procedure?  I don't see anything on how to do that in the
documentation.  There are no IN parameters in my test procedure, but
I'll need them for the stored procedures that I want to write.

From reading the documentation that comes with the plugin, it seems that
you use the getRow function to get the OUT parameter and presumably the
return value of a stored function.  Can anyone confirm this?

Thank you
-- Rick

2. costs of inserts and influence of caching tables and foreign keys etc

3. Backup of SQL 2K with Backup Exec 8.6 SQL agent

4. CRecordset GetFieldValue does not return correct values for nvarchar columns

5. Plug-in for Weekly Backups

6. looking for a good database package for Windows

7. SQL Will not start With NICs Plugged in

8. SQL Demo

9. Newbie needs MMC plug-in for SQL Server

10. HP Openview plug-in for SQL Server...

11. 3rd party plugin to simplify ADO interface to SQL

12. Can Variables be plugged into SQL statements??