Oracle crash on error

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
RoarkHulet
Posts: 2
Joined: Mon Mar 31, 2014 6:26 pm

Oracle crash on error

Post by RoarkHulet » Mon Mar 31, 2014 7:33 pm

I am currently using an app that I built with Livecode 5.5.2 Build 1492. I use the app all the time to query Oracle. During testing today if the query results in an error I get "revdberr," as expected. I decided to update the app to Livecode 6.6.0. When I tried the exact same query in Livecode 6.6.0 build 4003 it crashes the app. I have also tried Livecode 6.5.2 build 3014 with the same results. I did not test any other versions between 5.5.2 and 6.5.2. I am doing both of these tests in debug mode but I have also created a standalone app for both 6.6.0 and 5.5.2 with the same results.

I could not find this problem listed in bugzilla. Would it be possible for someone to test this on a working livecode Oracle app they have built and see if this problem is just isolated to me. When I am querying in 5.5.2 I get "revdberr," as expected. With 6.6.0 it crashes.

A valid Database_ID was obtained in all cases and a query tested that did not result in a error was checked first to make sure the process was working as it should, then an error was introduced into the query in the form of a misspelling of a table name, field name or a use of non_existent field name was tested with the crash in 6.6.0, 6.5.2 and "revdberr," in 5.5.2. I have a commercial license for both and I am testing in Windows 7.

Testing against SQLite in 6.6.0 results in a "revdberr,". This is the only other database I tested it against.

I have a work around for my app, but it concerns me that some query I write might result in a error and it will crash the app.

Thanks in advance.

Roark

RoarkHulet
Posts: 2
Joined: Mon Mar 31, 2014 6:26 pm

Re: Oracle crash on error

Post by RoarkHulet » Mon Mar 31, 2014 8:06 pm

Perhaps I should have restated the title. Oracle doesn't crash, my app crashes.

Thanks

Post Reply