![]() ![]() I'm just trespassing :)Ĭan you please provide me an example of how to do it. And you better check back to see what he has to say. until you commit, other sessions will still select * from z Īnd won't be able to change (locked out) those 5 records.Īnyway, better stop before Tom tells me "get your won site". Open p_rs for select rowid r, x from z where x > variable u exec z_pkg.p2(5,:u) Īnd BTW. just re-open based on the same criteria after the update took place This interactive option works if Python and pyODBC permit the ODBC driver to. Following function returns a cursor bound to a query CREATE FUNCTION reffunc1 (text) RETURNS refcursor AS ' DECLARE mycursor CURSOR FOR SELECT col FROM test where col1 BEGIN OPEN mycursor RETURN mycursor END ' LANGUAGE plpgsql I needed to make the returned cursor 'WITH HOLD'. ![]() Here is the SQL definition: CREATE TABLE MYTABLE ( MAIN INTEGER, OBJECT LO ) The ODBC DSN I used in the example is named pgsqltestblob. In the example the database used has one table with only two fields. ![]() Open p_rs for select rowid r, x from z where x > p_y for update Call the cursor method execute and pass the name of the sql command as a. Installed and properly configured the latest version of the PostgreSQL ODBC driver. Its name is a combination of My, the name of co-founder Michael Wideniuss daughter. retain it between sessions, go to Tools Options Database ODBC and select. MySQL is an open-source relational database management system (RDBMS). Procedure p2 (p_y in int, p_rs in out rc) Download and install the necessary ODBC driver to use for your PostgreSQL. Not sure what result set you want to see: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |