Sqlforms 3 , oracle error ORA-01001 - invalid cursor
From: Colin Berrouard <colin_at_mais.hydro.qc.ca>
Date: Tue, 19 Jan 1993 15:29:55 GMT
Message-ID: <colin.727457395_at_tdsb-s>
Date: Tue, 19 Jan 1993 15:29:55 GMT
Message-ID: <colin.727457395_at_tdsb-s>
Working environment:
SUN: SUN OS v4.1 Oracle: v6.0.33.1.1 PL/SQL: v1.0.32.3.1 SQL*FORMS(runform) v3.0.16.7.1 I have a peculiar error when I execute a certain FORM that CALLs another one. the error is 'ORA-1001 Invalid Cursor'. This error appears either in the first form or in the CALLed form. It is very erratic in nature, but eventually, I always get the error. All the SELECTs were converted into CURSORs, but that didn't change anything. Sometimes, I get the error 'ORA-1475 must reparse cursor to change bind variable datatype' instead of 'ORA-1001'. Would it have something to do with memory allocation and/or management ?? Any help would be greatly appreciated. Thank You Please , email any suggestions to colin_at_mais.hydro.qc.caReceived on Tue Jan 19 1993 - 16:29:55 CET