Multiple commands in one window in Oracle

[Former Member]

We're running IQMS with the Oracle back end.

Using IQMS' Data Dictionary, we're able to run multiple Oracle commands in one window by separating them with semicolon-slash ";/". I try this in Crystal XI and it gives me an ORA-00911 error (invalid character). If I try just the slash, I get an ORA-00922 error.

What is the "magic combination" to separate Oracle commands? Is there one? Due to the structure of IQMS, there is a bill of materials (BOM) header that contains the materials of the part we're casting, then a link to the item master for any other parts and sub-assemblies. The stock report goes only 4 levels deep on the BOM. I need to go infinite levels, so I'm looking at a recursive call via a function or stored procedure on the fly to a temp table.

[Former Member]

That leaves a rather large gaping hole when it comes to creating multi-level BOM's, particularly with the structure that IQMS left for us.

Would linking the Oracle tables to SQL Server and then querying SQL Server get around that limitation? Or am I forced to create a once-a-day procedure to update BOM's within Oracle and query that? The reason being is that we have an up to 4-shot injection process and IQMS forces the BOM list through 6 table joins to arrive at subordinate parts (STANDARD > PARTNO > PARTOPER > SNDOP > OPMAT > ARINVT (item master)) with separate call-outs for labor and materials (which could have sub-materials) of the same 6 tables. Needless to say, after 4 levels the entire table tree for just that gets very unwieldy and threatens to become a bowl of DBA spaghetti.

[former_member11696]

Crystal Reports does not support Oracle Commands. We added Subreports so you are able to run multiple data sources.