I would suggest you try to build a new data object and see if that works.
[EMAIL PROTECTED] wrote:
>After adding a few fields to my Oracle 8 database (native driver), and then to the
>corresponding ND data objects, and
>recompiling my whole project, my ND pages return the following error:
>orra.obEdtPlLoad.triggerDatabaseErrorEvent: execution of the DataObject 'obEdtPlLoad'
>has failed:
>orra.obEdtPlLoad. System error code is 5 ([SERVERERROR] Error from Server: ORA-00904:
>invalid column name )
>
>My column-names are well-formed, shorter than others which give no errors, only
>alpha- and underbar characters.
>The Studio allows me to "View Data" on these objects, where the new columns are
>visible, but NULL-filled. Oracle gives
>no error messages, either when adding the fields (with "modify table" commands), nor
>when running a select in SQL Plus.
>With RDBMS service logging turned up, it reports "cannot open sequential cursor" and
>"Invalid SQL results". However,
>when I paste the ND-generated SQL from the log into SQL-plus, it runs without error.
>It thus appears to be a ND problem.
>Anyone else run across this? Any ideas or suggestions? Thanks.
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
