[Zope-DB] DCOracle2 problem
Gor -
idontlikespam1111@yahoo.com
Mon, 5 May 2003 11:41:38 -0700 (PDT)
--0-322875955-1052160098=:14497
Content-Type: text/plain; charset=us-ascii
The stored procedures aren't doing anything "weird", python would crash with any stored proc. I tried installing Zope on a Linux box (now with DCOracle 1.3b), and received segmentation faults when I attempted to edit any stored proc. I then tried using another oracle user that was not the owner of any stored procs or packages. That second user was able to create dcoracle2 stored procedures using stored procedures from the first user's schema. The only problem was that when editing the dcoracle2 stored procedure, the second user had no known user-defined procedures, so the edit would fail because the drop down was empty. I added a stored procedure to the second user's schema to get around this. I experienced a segmentation fault again when I added a package containing a procedure to the second user's schema and then tried to edit a dcoracle2 stored procedure. Has anyone experienced any problems with packages containing procedures? Thanks, Eric
John Ziniti <jziniti@speakeasy.org> wrote:I've seen somewhat similar behaviour with DCOracle2
on UNIX (I get segfaults). This is usually when the stored
procedures I am using are returning "weird" things. SPs
with IN/OUT parameters are weird, as is 9i's XML_TYPE.
Is your SP doing anything funny that my be confusing
DCOracle2?
JZ
Gor - wrote:
>I'm having an issue with DCOracle2 in a Windows environment, and wondered if anyone else has experienced it. I am running Zope 2.6.1 on a Windows 2000 box, using DCOracle2 1.2 to connect to a Oracle 8.1.7 DB on a linux box. I am able to create and edit a Z Oracle DB Connection, as well as create and execute Z SQL methods. I can also create Z Oracle Stored Procedures, but once I click on them to edit them, python.exe crashes with: Application Error: The instruction "0x60497621" referenced memory at "0x00000000". The memory could not be "read". This happens on 2 different 2000 machines running Zope. Has anyone experienced this? Thanks, Eric
---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
--0-322875955-1052160098=:14497
Content-Type: text/html; charset=us-ascii
<DIV>
<DIV>The stored procedures aren't doing anything "weird", python would crash with any stored proc. I tried installing Zope on a Linux box (now with DCOracle 1.3b), and received segmentation faults when I attempted to edit any stored proc.</DIV>
<DIV> </DIV>
<DIV>I then tried using another oracle user that was not the owner of any stored procs or packages. That second user was able to create dcoracle2 stored procedures using stored procedures from the first user's schema. The only problem was that when editing the dcoracle2 stored procedure, the second user had no known user-defined procedures, so the edit would fail because the drop down was empty. I added a stored procedure to the second user's schema to get around this.</DIV>
<DIV> </DIV>
<DIV>I experienced a segmentation fault again when I added a package containing a procedure to the second user's schema and then tried to edit a dcoracle2 stored procedure.</DIV>
<DIV> </DIV>
<DIV>Has anyone experienced any problems with packages containing procedures?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV> </DIV>
<DIV>Eric<BR><BR><B><I>John Ziniti <jziniti@speakeasy.org></I></B> wrote:</DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">I've seen somewhat similar behaviour with DCOracle2<BR>on UNIX (I get segfaults). This is usually when the stored<BR>procedures I am using are returning "weird" things. SPs<BR>with IN/OUT parameters are weird, as is 9i's XML_TYPE.<BR><BR>Is your SP doing anything funny that my be confusing<BR>DCOracle2?<BR><BR>JZ<BR><BR>Gor - wrote:<BR><BR>>I'm having an issue with DCOracle2 in a Windows environment, and wondered if anyone else has experienced it. I am running Zope 2.6.1 on a Windows 2000 box, using DCOracle2 1.2 to connect to a Oracle 8.1.7 DB on a linux box. I am able to create and edit a Z Oracle DB Connection, as well as create and execute Z SQL methods. I can also create Z Oracle Stored Procedures, but once I click on them to edit them, python.exe crashes with: Application Error: The instruction "0x60497621" referenced memory at "0x00000000". The memory could not be "read". This happens on 2 different 2000 machines running Zope. Has anyone experienced this? Thanks, Eric</BLOCKQUOTE></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The New Yahoo! Search</a> - Faster. Easier. Bingo.
--0-322875955-1052160098=:14497--