Recent content by Pierre Maas

Goodmorning, When I debug a plsql package procedure that is also calling an other package procedure (other package) it hangs. This happens when I compiled the second package procedure and run the debugger (test window) again. The buttons are visible but nothing happened even ctrl break or...

Thanks Marco, It works now as usual !! Prettig weekend. Pierre Maas

Thanks for reply. Indeed I mean the < and > sign. If you open this exported data in Internet Explorer you see the correct data. But, this exported data I want to use this as input for Stylus Studio and then you see the replacements of the signs < and > . Ok, i can do find and replace to solve...

To all, When i do export the query results from a clob with xml nodes in then the "" signs are replaced by "lt;" and "gt;" (with a & in front) characters in notepad. How can i change these ? thanks in advance pjmaas

to all, When i do a "select userenv('LANG') from dual" I got the session NLS_LANGUAGE parameter, the value is different from the database or instance LANG parameter. Somewhere in PLSQL developer is for me a wrong NLS_LANGUAGE set. Do somebody know how to change this (not a change with "alter...

I found my problem. Used OCI version: 7.3 . Changed to OCI version 9.2 and now it is working. I have several Oracle Homes onto my desktop.

Same result. I shall send you the support info, is that ok for you ?

Sorry wrong language. Is there any solution in the near future ? I have the same problem. Pierre

Is enige zicht op een oplossing. Ik heb dezelfde probleem namelijk. Pierre

Hoi, thanks for the quick reply. Ok, with macros you can work around this. With templates, I changed one template and add the additional line. I want as default at the last line the "exit;". You see the this line show up when a new package has been choosen. When you compile this then an error...

Is there a possibility that in a .pck file, before the "create and replace package/body", automatically a sql statement can be placed. Like: set define off. I am also looking for a possibility to put at the end of the file sql statements automatically. Like: exit;