package refresh

Bruce Carson

Member²
We have an issue where we are developing packages in pl/sql developer against a 10.2.0.3 db and the package changes do not always seem to come back properly (although we confirmed that the compile is writing to the db). A quick flow to create the problem is as follows although does not happen every time.

1. change package
2. compile change
3. close package
4. reopen package (view or edit)
5. previous version of package displays
6. close package
7. reopen package
8. changes now there (proper version displays)

Seems the compile is writing to the db as it should but when retrieving sometimes grabs a copy from the cache or something.

At this point I am wondering if this is already a reported bug with Allround Automation.

Our environment is as follows
Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16

Can send more if required.

Thanks.
 
Back
Top