Search results for query: *

Mufasa, I am working on a data mart as part of a commercial package. Each customer will have its own data mart and production database, which will initially be cloned from a base version. We don't want to hard-code the logon/password/schema information into every version of the data mart. As...

OK, but my proc will not compile with the simple connect statement in it, so what's the solution? BTW, I am using 10g... Thanks! Mike

All, When I execute this from within a stored proc, I receive an "Invalid SQL" error: EXECUTE IMMEDIATE ('connect DMart_Phase2/dmartphase2@MXDOWL02'); Any help appreciated. TIA, Mike

If I try to execute the following: GRANT SELECT ON DMART_TEST.ERACCOUNTDIM TO FINANCE_ML_QA; I receive a "Table or View does not exist" message. If I add the database: GRANT SELECT ON MHBENG02.DMART_TEST.ERACCOUNTDIM TO FINANCE_ML_QA; I receive a "Missing keyword" error message. Any...

All, I need to link in tables that are in a different schema. How can I do this in a stored proc (as opposed to SQL*Plus). I'm coming back to PL/SQL after working with T-SQL and I'm a little rusty... In addition, I couldn't find how to do this in any of the 7 PL/SQL books available to me...

Another option is to create a table - CurrentMonth - that is truncated and refreshed as needed with the current month's data and to use this in your report. Another option is to have a single table and use Between to filter on the month-begin and month-end dates (which can be passed as...

You are going to have to use dynamic SQL, either in your front-end application or in Oracle. I would use a stored procedure to calculate the table name and use dynamic SQL within the stored procedure to create and submit the SQL statement. Mike

Thanks for the information. The report requires 3 different displays of data and all 3 require a detail row. If you or anyone else knows how to do this within a single report, I'd love to hear about it. Thanks again! Mike

I am working on a report that will consist of 3 sub-reports. The data for all 3 sub-reports comes from a single stored procedure. I am opening the stored procedure in the master report. Is there some way to share this datasource among the 3 sub-reports? TIA, Mike

Thanks for your help! It turns out that Dave's suggestion does the trick. Mike

Thanks for the response. I tried spoofing CR by changing the datasource to a SQL statement: "EXEC dbo.pr_PendingJournal @p_StartDate, @p_EndDate, "PENDED"". When I create the 3 parameters and try to save it, I receive a "must declare the variable @p_StartDate" error. However, I can create a...

I have a CR 9 report that calls a SQL Server 2000 stored procedure. The SP requires 3 parameters. One of the parameters tells the SP which transaction type to select. I want this parameter to be hard-coded, that is, I will set it differently in every report that uses this SP. I want the report...