$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
Former Member

Multiple commands in one window in Oracle

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 09, 2017 at 05:12 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2017 at 02:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded