Recent content by mmontesano

Does your table V_TRACK actually have a row with a blank KEYS_TEXT column? If so is the column NULL or a space? If not, you could either add such a row to V_TRACK or change the LOV select to be: select distinct keys_text from v_track union select ' ' from dual Please let us know if you find...

1) It is difficult to recreate the constraints since the constraints are FROM other tables to COMPANY. You could look at the tables USER_CONSTRAINTS and USER_CONS_COLUMNS. These are data dictionary views of the constraints on every table owned by the current user. To see all the constraints...

I may be missunderstanding your question. PL/SQL doesn't really support a direct user input/output interface. Oracle provides other tools for this (Developer 2000). Additionally, before any PL/SQL code executes, the user must have already logged on to the database. Could you give more...

You're welcome. monte

naresh- Let me restate what I think you are asking: Test variable1 and if its value is 'mercury' and the hiredate is 1-jan-99 or the matl_name is 'steel' include the record. If variable1 isn't 'mercury' and the matl_name is 'iron' include the record. If neither case is true exclude the record...

I'd say it's closer to Pascal than C/C++. It's not really object oriented. It is structured. It has user definable types (but not very rich). It is *not* strongly typed since it will try to perform automatic type conversions. If you need a tutorial on the language, my favorite book is...

I have run into a similar problem (though I don't recall the error message) with the run_product command. In my case, I had to change: run_product(REPORTS,'c:x.rep',SYNCHRONOUS,RUNTIME,DB,NULL); to run_product(REPORTS,'c:x.rep',SYNCHRONOUS,RUNTIME,DB,''); Replacing the NULL with ''...