bug with for update in 7.1

sukhadukkham · Apr 24, 2007

do a select with for update and try to fetch last record. this will result in "ora-01002" message.
same select with t.* and t.rowid works fine.
regards
daniel

Marco Kalter · Apr 24, 2007

Works fine for me. Is there anything special I need to do to reproduce this?

sukhadukkham · Apr 25, 2007

it happens on every table ( nothing special ). please find the pldev information below and let me know if you need additional information.

PL/SQL Developer
Version 7.1.0.1337
29645 - 20 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1'047'784 kB (592'904 available)
Paging file : 2'520'912 kB (2'233'420 available)
Virtual memory : 2'097'024 kB (1'983'580 available)

Parameters
C:\Program Files\PLSQL Developer 7.1 Beta\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer 7.1 Beta\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer 7.1 Beta\Preferences\dwe\default.ini

Plug-Ins
texType (2.5) - www.softema.com (C:\Program Files\PLSQL Developer 7.1 Beta\PlugIns\texType.dll)
*External Tools 1.0 (C:\Program Files\PLSQL Developer 7.1 Beta\PlugIns\Tools.dll)
*wList (2.4) - www.softema.com (C:\Program Files\PLSQL Developer 7.1 Beta\PlugIns\wList.dll)
(* is Active)

Aliases
AET_SAETDELTA-1_ET3K1
AET_SAETDELTA-2_ET3K1
AET_SAETDELTA-TEST_ET3K1
AET_SAETDELTA-TEST_OEMREP
ATEL_WETENT01_ET34
...

Homes
ora10gR2 (c:\oracle\10gR2)
ora6idev (C:\orant)

DLLs
c:\oracle\10gR2\bin\oci.dll

TNS File
c:\oracle\10gR2\Network\Admin\tnsnames.ora

Using
Home: ora10gR2
DLL: c:\oracle\10gR2\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.7.0

Character Sets
Character size: 1 byte(s)
CharSetID: 46
NCharSetID: 2000
Unicode Support: True
NLS_LANG: GERMAN_GERMANY.WE8ISO8859P15
NLS_CHARACTERSET: WE8ISO8859P15
NLS_NCHAR_CHARACTERSET: AL16UTF16

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ET3K_PW = Y
ORACLE_HOME = C:\orant
ORACLE_HOME_NAME = ora6idev
SHARED_ORACLE_HOME = C:\orant
API = C:\orant\DBS
NLS_LANG = GERMAN_GERMANY.WE8ISO8859P15
COMPANY_NAME = delta
ORACLE_GROUP_NAME = Oracle for Windows NT
ORACLE_JDK = C:\orant\JDK\
OI_NLS32 = C:\orant\orainst\NLB
RDBMS80 = C:\orant\RDBMS80
PLSQL80 = C:\orant\PLSQL80
CORE40 = C:\orant\CORE40
NLSRTL33 = C:\orant\NLSRTL33
ORA_NLS33 = C:\orant\NLSRTL33\DATA
PRO80 = C:\orant\PRO80
OTRACE80 = C:\orant\OTRACE80
NET80 = C:\orant\NET80
SQLPATH = %sqlpath%;C:\orant\BROWSE60\SQL
PLUS80 = C:\orant\PLUS80
EXECUTE_SQL = PLUS80
PLUS_DFLT = PLUS80
MM60 = C:\orant\TOOLS\COMMON60
UI60 = C:\orant\TOOLS\COMMON60
TK60 = C:\orant\TOOLS\COMMON60
FORMS60 = c:\orant\forms60
VGS60 = C:\orant\TOOLS\COMMON60
DE60 = C:\orant\TOOLS\COMMON60
CA_GPREFS = C:\orant
CA_UPREFS = C:\orant
QT_PLAYER = OMO
DEV2000_SOURCECONTROL = NONE
DEV2000_PROJECT = NONE
DEV2000_SCVIEWER = NOTEPAD.EXE
DEV2000_SCCONVERT = FALSE
DOC60 = C:\orant\TOOLS\DOC60
OIN60 = C:\orant\OIN60
ORAINFONAV_DOCPATH = C:\orant\OIN
ORAINFONAV_CDPATH = E:\tmp\ORACLE-FORMS-DEVELOPER6-RELEASE2\INSTALL
BROWSER60 = C:\orant\BROWSE60
GRAPHICS60 = C:\orant\GRAPH60
OCL60 = C:\orant\GRAPH60
GRAPHOGD60 = C:\orant\GRAPH60\GWIZ_OGD
GRAPHBMP60 = C:\orant\GRAPH60\GWIZ_BMP
GWIZARD60 = C:\orant\GRAPH60
OIN = C:\orant\OIN
doc60_nls = C:\orant\TOOLS\DOC60\US
RW60 = C:\orant\REPORT60
REPORTS_RUNTIME = rwrun60.exe
REPORTS_BUILDER = rwbld60.exe
REPORTS60_SPLASH = TRUE
REPORTS60_EXPRESS_UI = C:\orant\bin
GSINSTALLDIR = C:\orant\olap\ece620
GSCONNECTDIR = C:\orant\olap\ecf620
REPORTS60_PATH = O:\Standard6i\Forms;O:\Standard6i\Object_Library
REPORTS60_TMP = C:\orant\REPORT60\TMP
REPORTS60_JNI_LIB = C:\orant\jdk\bin\javai.dll
REPORTS60_CLASSPATH = C:\orant\jdk\lib\classes.zip;C:\orant\REPORT60\java\jars\myreports60.jar;C:\orant\REPORT60\java\jars\xmlparser.jar
REPORTS60_DEV2K = FALSE
FORMS60_PATH = O:\Standard6i\Forms;O:\Standard6i\Object_Library
UI_ICON = E:\ET3000\ICONS;O:\Standard6i\Icons

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = ora6idev
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = ora6idev
PATH = C:\orant
NLS_LANG = GERMAN_GERMANY.WE8ISO8859P15

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_HOME = C:\orant
ORACLE_HOME_NAME = ora6idev
SHARED_ORACLE_HOME = C:\orant
API = C:\orant\DBS
NLS_LANG = GERMAN_GERMANY.WE8ISO8859P15
COMPANY_NAME = delta
ORACLE_GROUP_NAME = Oracle for Windows NT
D2K60_COMPONENTS = Oracle Forms & Reports 6i Comps
D2K60_ADMINISTRATION = Oracle Forms & Reports 6i Admin
D2KOR60_ADMINISTRATION = Oracle Reports 6i Admin
D2KIF60_ADMINISTRATION = Oracle Forms 6i Admin
D2K60_DEMOS = Oracle Forms & Reports 6i Demos
D2K60_DOCS = Oracle Forms & Reports 6i Doc
D2K60_GROUP = Oracle Forms & Reports 6i
D2KOR60_GROUP = Oracle Reports 6i
D2KIF60_GROUP = Oracle Forms 6i
D2K60_DRIVERS = Oracle Forms & Reports 6i Direct Drivers
OPEN2K60_DOCS = Oracle Forms & Reports 6i Doc
OI_NLS32 = C:\orant\orainst\NLB

SOFTWARE\ORACLE\KEY_ora10gR2
ORACLE_HOME = c:\oracle\10gR2
ORACLE_HOME_NAME = ora10gR2
ORACLE_GROUP_NAME = Oracle - ora10gR2
NLS_LANG = GERMAN_GERMANY.WE8ISO8859P15
ORACLE_BUNDLE_NAME = Enterprise
SQLPATH = c:\oracle\10gR2\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_ora10gR2
MSHELP_TOOLS = c:\oracle\10gR2\MSHELP
ORACLE_BASE = c:\oracle
RDBMS_CONTROL = c:\oracle\10gR2\DATABASE
RDBMS_ARCHIVE = c:\oracle\10gR2\DATABASE\ARCHIVE
ORA_ET3K_AUTOSTART = TRUE
ORA_ET3K_PFILE = E:\oracle\admin\et3k\pfile\initET.ora
ORA_ET3K_SHUTDOWN = TRUE
ORA_ET3K_SHUTDOWNTYPE = immediate
ORA_ET3K_SHUTDOWN_TIMEOUT = 90

SOFTWARE\ORACLE\ORACLE_HOMES

SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE0
ORACLE_HOME = C:\orant
ORACLE_HOME_NAME = ora6idev
SHARED_ORACLE_HOME = C:\orant
API = C:\orant\DBS
NLS_LANG = GERMAN_GERMANY.WE8ISO8859P15
COMPANY_NAME = delta
ORACLE_GROUP_NAME = Oracle for Windows NT

c:\oracle\10gR2\bin
C:\orant\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\ATI Technologies\ATI Control Panel
C:\orant\jdk\bin
C:\Program Files\Common Files\GTK\2.0\bin
C:\Program Files\QuickTime\QTSystem\
C:\Program Files\OpenVPN\bin

LOKAL_ET3K =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ET3K)
)
)

ifile=c:\oracle\tnsnames.ora

Marco Kalter · Apr 25, 2007

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

sukhadukkham · Apr 26, 2007

debug.txt has been sent to support@allroundautomations.com with the following subject:
Debug.txt for forum Topic: bug with for update in 7.1

Marco Kalter · Apr 26, 2007

I don't think we received it. Can you resend it?

sukhadukkham · Apr 26, 2007

did resent

sukhadukkham · Apr 27, 2007

all my mails send to you come back. any idea?

Marco Kalter · Apr 27, 2007

What is the error when the e-mail comes back?

You can also post the section of the debug.txt file that includes the ora-01002 here.

sukhadukkham · Apr 30, 2007

hi marko,

hope this helps:

26.04.2007 08:08:43 TSQLForm.ThreadFinished: SQLThread.Suspended
26.04.2007 08:08:43 SQLForm 52 rows selected in 2.814 seconds (more...)
26.04.2007 08:08:43 TOracleQuery PLSQLDevForm.StatQuery Start Query.Execute
SQL = select value from v$sesstat where sid = :sid order by statistic#
:SID = 17
26.04.2007 08:08:43 TOracleQuery PLSQLDevForm.StatQuery End (251 records processed)
Duration = 0.01
26.04.2007 08:08:43 TOracleSession $0160E9D0 Start Session.Commit
26.04.2007 08:08:43 TOracleSession $0160E9D0 End
Duration = 0
26.04.2007 08:08:43 TOracleQuery Query Start Query.Execute
SQL = begin :id := sys.dbms_transaction.local_transaction_id; end;
:ID = Null
26.04.2007 08:08:43 TOracleQuery Query End
Duration = 0
26.04.2007 08:08:43 NavigationBookmarks.EnableButtons(Rebuild)
26.04.2007 08:08:43 NavigationBookmarks: Backward=0, Forward=0
26.04.2007 08:08:43 TOracleQuery $02D14C30 Start Query.Execute
SQL = begin
sys.dbms_output.get_line(line => :line, status => :status);
end;
:LINE = Null
:STATUS = Null
26.04.2007 08:08:43 TOracleQuery $02D14C30 End
Duration = 0.01
26.04.2007 08:08:43 SQLForm 52 rows selected in 2.814 seconds (more...)
26.04.2007 08:08:43 NavigationBookmarks.EnableButtons(Rebuild)
26.04.2007 08:08:43 NavigationBookmarks: Backward=0, Forward=0
26.04.2007 08:08:43 SQLForm Executing...
26.04.2007 08:08:43 TSQLThread SQLThread Suspend ended
26.04.2007 08:08:44 TOracleQuery $02D14EF0 Start Query.Next for up to 1 record
26.04.2007 08:08:44 TOracleQuery $02D14EF0 End
Result = ORA-01002: FETCH auf ung

Marco Kalter · Apr 30, 2007

Hmm, I think I need the whole file. Can you try to send it again? Maybe from a different e-mail address?

sukhadukkham · May 2, 2007

i've send the file from a different email

sukhadukkham · May 11, 2007

any news on this?
meanwhile tested this with another pc => same result

Marco Kalter · May 11, 2007

I have no news. I can't reproduce it, and I have no clue why this happens.

bug with for update in 7.1

sukhadukkham

Member³

Marco Kalter

Administrator

sukhadukkham

Member³

Marco Kalter

Administrator

sukhadukkham

Member³

Marco Kalter

Administrator

sukhadukkham

Member³

sukhadukkham

Member³

Marco Kalter

Administrator

sukhadukkham

Member³

Marco Kalter

Administrator

sukhadukkham

Member³

sukhadukkham

Member³

Marco Kalter

Administrator

Similar threads