Recent content by marybeth

How do you handle strings that have an apostrophe inside of it? The importer is taking my string and placing single quotes around it, which is correct, but isn't placing an additional single quote within the string. For example, I'm trying to import the word gov't as a string and it is doing...

My version is 7.0.0.1050 01.30119

Our open cursors are set to 255 which should be plenty. Any other ideas, or do you think this is a bug?

I used text importer to create a script which was inserting 284 records. About 2/3 of the way I received this error: ORA-01000 maximum open cursors exceeded. I added several commit statements throughout the script but it still happened. Any ideas as to what this means?

I had the same problem with varchar2's. I saved a spreadsheet as a .csv and noticed that if the column contains all numbers then a single quote will be placed around it, but it doesn't do the same with regular letters. This is obviously a bug. However, I had to do a substring on the column and...