You searched for the word(s): userid:745664

More Search Options

RSS Available

• Dump formatted datatable to PDF

  Using pivoting and analytics and other such newly learned tricks, I have created a report with header and labels in Oracle. Can I dump the report directly onto a PDF page with Crystal. I am using visual studio 2005 2.0

  Posted to Crystal Reports (Forum) by row118 on 10/27/2009

• DateTime vs TimeStamp Oracle

  The following won 't work. Private _businessDate.ToString("dd-MMM-yyyy") Dim cmd As New OracleCommand With cmd cmd.CommandText = "YELLOWFARMS.GETRPTDATA" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = conn End With Dim oparam As OracleParameter oparam = cmd.Parameters.Add("BusinessDate", OracleDbType.Date) oparam.Value = _businessDate.ToString("dd-MMM-yyyy") oparam = cmd.Parameters.Add("p_rcDOR", OracleDbType.RefCursor, ParameterDirection

  Posted to Oracle (Forum) by row118 on 10/12/2009

• Re: DateTime vs TimeStamp Oracle

  Oracle kept throwing the "Picutre ends .."error when date not in default oracle format 'dd-MMM-yyyy'. Do you have working VB and Oracle snippet that works.

  Posted to Oracle (Forum) by row118 on 10/12/2009

• Re: DateTime vs TimeStamp Oracle

  I meant do you have the corresponding WORKING oracle script? The problem is the date format must match that of the database format which is 'dd-MMM-yyyy'. So changing to your code doesn't work. The reason why my first method works is because the literal '24-Aug-2009' is in correct format. There should be no difference in results when I use the to_date function.

  Posted to Oracle (Forum) by row118 on 10/12/2009

• Re: CR Newbie: Can't do simple sum

  One other note. When I try to insert a graph using the Chart expert, the OK button is grayed out. Is this a licensing thing?

  Posted to Crystal Reports (Forum) by row118 on 5/25/2009

• CR Newbie: Can't do simple sum

  I'm designing a simple Crystal Report in VS.NET 2005. I am using an XML file as my datasource . I am trying to sum my Week To Date sales field. But Whenever, I add "running total", to the Group Footer, I don't get "Sum" in the dropdown. I get maximum, minimum, count, distinct count, etc...everything except plain-jane "Sum". Then, when i try to add an unbound number field and do sum({REportTable.WTDSales}), i get "There is an error in this formula. Save it

  Posted to Crystal Reports (Forum) by row118 on 5/25/2009
  Filed under: Sum, Crystal Report, XML datasource

• Re: Passing a .NET collection to a Oracle Stored procedure?

  I followed this link suggested:And got the same errors as above. When I executed on 10g, I had no problems. everything worked like a charm. I had been using the 9i client.

  Posted to Oracle (Forum) by row118 on 5/19/2009

• Re: Passing a .NET collection to a Oracle Stored procedure?

  Ho do i put this is a code window? Sorry about the formatting. I get the same errors when I execute this statement: CReate type mytype as table of varchar2(100); / select * from table (mytype('1','2','a')) / ERROR: CReate type mytype as table of varchar2(100); * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [0x59E057D4], [], [], [], [], [], []

  Posted to Oracle (Forum) by row118 on 5/19/2009
  Filed under: .net 2.0, ODP.NET Oracle, commandtext "command object" "returning a dataset", oracle 10g provider, odp.net Oracle user defined type

• Re: Passing a .NET collection to a Oracle Stored procedure?

  John this is exactly what I'm trying to accomplish. The following is pseudocode for my Oracle Stored Proc. CREATE PROCEDURE SelectFromList ( delimitedList varchar2(100); -- --- or type TableValues of number; AS BEGIN Select * From MyTable Where StoreId in (5,6,7,8) ; OR Select * From MyTable where StoreId in ( select Storeid from the table input) END ; -------------------------------------- With passing in the table , what type of variable and how is it populated from cmd parameters in web page

  Posted to Oracle (Forum) by row118 on 5/19/2009
  Filed under: Oracle, odp.net, delimited list, command types

• Re: How to call an oracle function with a user defined type as parameter

  Does this work for Oracle10g?

  Posted to Oracle (Forum) by row118 on 5/19/2009