Recent content by BobGeezer

Okay, okay, do I feel stupid? This is the same old problem we've had before of positional .vs. named parameters. Default is pmPositional. We use pmNamed.

Good morning, The following Delphi cannot call the procedure below. Please can you point out where we've gone wrong? It fails with the following error: --Error--> ORA-06550: line 2, column 3: PLS-00306: wrong number or types of arguments in call to 'GET_BOOK_PAGE_NO' ORA-06550: line 2...

I see now it is not possible :-( I know we had problems with Direct Path Loader originally, but can that load large CLOBs? We could have another try if so. Reference for array DML: " Array DML does not allow for LOB Locators. It only works with scalar data types like varchar2, number, date...

Hi im2kul, I expect you have worked around this already, but just in case.... Create a new variable of the approrpiate type and assign the value to it in the loop. Then assign the variant array element from it. You will be able to see the original value. If you want to see what the array...

Mornin' Marco, All, We can find no mention of Array DML used with BLOBs. Is this possible? Do we "simply :-(" create an array of variants holding references to TLOBLocator objects? We're using array DML extensively in transferring data from Interbase to Oracle. We've managed to avoid BLOBs...

Thanks dozey. There is a commit. Missing the commit would have stopped both seeing it I expect. We have moved on. Perhaps it's something to do with read snapshot and/or read committed or something and PL/SQL Developer. This is a minor concern now. No further responses required, Ta.

Hi Marco, Thanks, but that means Oracle is not a relational database!!!!! One of the fundamental rules of relational databases is the NULL is a distinct value separate completely from all data values. Have you any idea when Oracle plan to fix this bug? How can people work with this...

We're loading table using create table and then array DML of 250 rows at a go. We get "ORA: 01400 Caonnot insert NULL value into (user,table,column)" ... where column is a non-NULL nvarchar2(20) column. When I step through the code, there are no NULL values going into the array. Only _blank_...

We have an OLTP system. Rebooking a "call" results in two bookings made for delivery. On one development machine, we see both bookings by pressing F8 in PL/SQL Developer SQL Window. This is good. On another development machine using the same tnsnames.ora and PL/SQL Developer, only one extra...

Thank you Marco, you are truly a hero!

Hi Marco, Yes, I've tried every possible combination of date formats and every possible NLS_TIMESTAMP_FORMAT and NLS_DATE_FORMAT I can think of including simply using 'DD-MM-YY' ignoring the time and I can't get it to work. I've given up and I'm now trying to "fit in with Oracle" and use...

Hi Marco or anyone who's used dates and times, I've tried loads of things with direct path timestamps and got nowhere. I then discovered that if we accept the limitation of "no milliseconds" then a "date" column will suffice. However, with ODPL, I find there is no date type (only dpString...

Hi again Marco, Trying array DML instead of DPL for simplicity, we get error: :INSERTDATE is a complex variable and cannot be an array Does this mean array DML doesn't work for timestamps? If so, is there a remedy in the pipeline please? ...Again, one simple working example of DPL with...

Hi All, Using the loader, we want to load a row with integers, strings and dates/times/timestamps. Strings and integers are OK. In desperation, we're trying to assign the date values as strings. Is there a simple example of this? Is there any example of dates in direct path loader? The...

Hi Marco, This is a poor solution. I guess it's a limitation of Oracle itself rather than a limitation of DOA? Thanks for the help. So, otFloat it is....