Search results for query: *

When I execute my Dynamic sql statement, I get an missing keyword error because it sees a single quote value. Is there a way to replace the single quote value? Thanks Ram

I have dyanamically built a Merge statement and I am trying to do an Execute Immediate on it. I am able to run the Merge statement individually without issues. When the same is done through the Execute Immediate it fails: ORA-00001: unique constraint (GPS.DETAILS37150433_PK) violated. MERGE...

I am passing one parameter to a function and the return datatype is a number. When I run the sql itself I get the correct value but the function returns a different value. Thanks

I have a cross tab report (Crystal Enterprise 10 ) built on a business view. When no rows are returned CRW32.exe generates an error and crashes. Things I've done so far: 1. On the cross tab expert - checked "suppress empty rows" check box. 2. created a normal report using the same business...

I am trying to debug some dynamic sql in a stored procedure and I need to output the contents of the string variable. Thanks for your help in advance.

I have declared a procedure, function "con_event_dt" and a variable "v_subm_dt_id" in the package specification. In the Package body I am trying to execute the following query: v_str_sql:= SELECT 'card_cd, con_event_dt(v_subm_dt_id,card.card_wip_id_cd) as...

I have declare a REF cursor in the Package Specification: TYPE type_cur IS REF CURSOR RETURN track_rec_type; PROCEDURE prg_ConceptTrackMatrix_rpt(cur_TrackMatrix IN OUT PRG_EDP_REPORTS.type_cur); In the Package body: v_str_sql:= 'select card_cd as card_num from table_card'; v_openCur:=...

Is it possible to do something like this to create a view; Select * from ( Execute Stored_Procedure_name ). Thanks in advance.

Is there a limit ot the number of rows that a reference cursor can return?

I am using SQL Navigator 3.2 and I have the "server output" checked. When I execute a statement BEGIN DBMS_OUTPUT.PUT_LINE('TEST'); END; I cannot get to see the output. Could you please let me know what other settings I need to turn on. Thanks

I have set-up a combo box to load on the drop down event and the combo box style property is 2- dropdown list. The problem I'm facing is, the list portion of the combo box does not drop sometimes. There are no errors on loading the combo box and I have Do events in place. Does anyone have a...

I'm trying to get the output values of a stored procedure into a table as below Insert #temptable Exec Stored_proc @param1, @parm2 I thought that this was possible but I get this error message. "An INSERT EXEC statement cannot be nested." Is this possible at all?

I have always used NT authentication (trusted connection) to logon to SQL server but now I'm forced to use the SQL Server's native security. I've created a DSN to make a connection to the SQL Server database but can anyone help me build the connection string in VB (using the DSN) but...

When exporting a landscape report to Excel. In the Excel spreadsheet the page setup scaling in set to 10% insead of 100%. This happens only when working in the Citrix environment.Can anyone suggest a fix for this. Thanks in advance. using: Crystal Reports 8.5 Windows 2000 advanced server

My Stored procedure makes 6 different queries to pass the filtering test and if any one of them fail, I need to return an appropriate message to the front end, else if it succeeds then I need to return the recordset for furthur processing in the front end. I, presently have an Output parameter...

How can I connect / read from a Word Pad Document into Crystal Report 8.0 ?

When trying to establish an ODBC connection to a text file for Crystal Reports the following error occurs when the guess command button is depressed: The error message cannot update. Database object is read only. ----- How can I establish a ODBC connection to a file with a .RTF extension?

I am trying to use the RDC for the first time. I have imported an existing .RPT file and added the report viewer to my VB project. The reference material I have been referring to states that: "The report inside your VB application will use the same data source as the imported report did...

I need to pass a form as an arguments to sub routine in a Module. I get a type mismatch error? What's wrong with this? Thanks! in the Form module: loadListBox(frmABC) in the BAS Module: Sub loadListBox(formName as form) End Sub

I have gone through Some of the related issues in this Forums but have not found a solution to the problem of printing the report exported to Excel at the normal size without having to fix this manually. Has anyone found a solution for this? Thanks.