Search results for query: *

Please forgive me for a pretty basic question but I would like to find the way to determine the paramaters of a an Oracle stored proc by querying the system. I believe there was a stored proc or a function that would provide this information for Oracle 10g but I cannot locate the name of the...

I have little experience with db2 and am trying to create a new procedure by following the example and modifying it to fit my needs I found on IBM's web site I cannnot see the problem with this The first error shows at "Begin" and I have noted the errors shown with the addition of the comment...

I am using SSRS 2005 to report from an Oracle database. The report is a bit complex to describe, but simply, I have a report that I need to assign a dataset to dynamically. if I can do so. Something like: ReportDataset = Query results. I am processing some data in VB.net code rather than...

I am very new with Oracle and am trying to debug legacy procs. The procs are not well designed in my opinion but it is what it is and I need to find out exactly where the errors occur. What I would like to do is figure out a way to add the actual line Oracle fails on and log it along with the...

I am using Crystal 10 and Crystal Enterprise 10 to report from an Oracle 10g database. The report accepts a variable number of input parameters to sort the records returned by an oracle proc. When I attempt to run from Crystal Enterprise, the report is not sorted when the report is formated as...

I have reduced a more complex problem to the simplest elements in the following selects. my select using a join does not return any data while the select using a sub select returns data as expected I have researched this forum as well as BOL and am finding nothing that explains where I am...

I am new to Oracle and have what should be a very basic question Basically, I cannot find out the syntax to execute an Oracle proc that returns a cursor as output. I have an cursor defined as a output prameter from an Oracle proc as well as 2 input parameters I need to call the Oracle proc...

Does anybody know of a method to quickly convert a Crystal report to Reporting services?. Perhaps there is a way to use the "Crystal Report Professional v10.0 (32-bit) - Report Definition" text file?? I have quite a few reports to convert and would like to speed the process up. From what I...

I have a report which will run properly, but which fails in Crystal Enterprise 10 with the following: Status: Failed Printer: The instance is not printed. External Destination: None Creation Time: 8/5/2010 9:46:18 AM Start Time: 8/5/2010 9:46:18 AM End Time: 8/5/2010 9:46:19 AM Server Used...

I am having a difficult time with selecting recors for a report The data source is an Oracle proc which accepts input parameters and returns the proper data The report has 2 additional parameters (numeric ranges) that I need to use to limit the records further When I place those parameters in...

Does anyone know if there is an upper limit to the number of UNIONs you can use in an Access query (Access 2003)?

This is probably pretty dumb, but I have not yet found the fix for my problem I am developing a web based app using ASP.Net with vb6 code behind. I want to use the input box function but the input box diplays minimized for some reason (or perhaps behind the web form??) Basically I have a web...

I am just starting with SSIS and need some basic information to guide me the right direction. I need to process some information from the database and create flat files or Excel speedsheets according to different criteria. I have a VB 6 application which contains the code to create these...

I am trying to create a report using Crystal 8.5. I have a fairly simple SQL statement to execute against an Oracle database, but I cannot seem to find a way to paste it into Crystal. I am not permitted to create a stored procedure in our Oracle database and Version 8.5 has no command object...

Microsoft has a downloadable sample of a help desk application for the .NET platform. I have seen it, but cannot seem to locate it on their site. Can anybody help me out?

Can anybody point me to a good tutorial on creating a dll using Com+ I have created dlls in the past with no problems but I am being told there are many differences in how dlls are written for Com +. I just need a quick overview by tomorrow morning and only as it reates to creating a COM + dll

We have a Server in the eastern time zone. users access this server through the web We also have sites around the country in different time zones. I need to store datetime values based on the local time of the user, not the server time. Basically I do not need to be 100% acurate, just the hour...

I have an interesting error occuring. I have simplified things down a bit to isolate the bug so bear with me. I have a complex stored procedure (sql server 2000) which receives several parameters and returns records. When I execute the procedure in Query Analyzer, things work properly and I...

Hope I do not sound like an idiot but I do not seem to be finding what I need. I created a view in a 7.31 Informix database to summararize certain columns. I now need to select the data from that view using a where clause. Select * from vifxView where scode = 'ABC-123' I need to create a...

I receive a syntax error that I cannot quite seem able to find in the following code. Can some one help me out? I am afraid I have minimal understanding of Informix. I want to call this procedure from SQL Server. I am using Linked servers and need to only select summarized data for a single...