Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tdhny
  • Order by date
  1. tdhny

    Dynamic Datawindows based on a stored procedure

    Here it is: string ls_sql = "'From Users'" /* String should be passed in a quote */ This was the key and the rest was same. sql_syntax = "execute starsdba.SP_PROVIDER_LIST; as_Sql=" + ls_sql presentation_str = & "style( type=Grid & Horizontal_spread = 25 & Header_bottom_margin = 15 &...
  2. tdhny

    Dynamic Datawindows based on a stored procedure

    I figured it out. Thanks for your suggestions though.
  3. tdhny

    Dynamic Datawindows based on a stored procedure

    My issues is I am trying to create a datawindow dynamically based on a SP with parameters. I could able to create a datawindow dynamically from a SP without parameters, but with parms I am getting this error - "Can not get parameters of procedure" Any suggestions please? My code: sql_syntax...
  4. tdhny

    Dynamic Datawindows based on a stored procedure

    Thanks for your solution, but I figured it how to build a dw based on SP. One more question for you? :) What would be the limit on length of a string ( it can be a string or comma separated values) we can pass from PB to Oracle Stored Procedure. I know from PL/SQL it is 32K, but would want to...
  5. tdhny

    Dynamic Datawindows based on a stored procedure

    Hello All, I am using PB 11.5 and Oracle 11g, my requirement is to create dynamic datawindows based on a oracle stored procedure ( i know it can be created by using syntaxfromsql by passing sql select statement, but to make it SQl injection proof I have to use SP). If any one has any ideas...

Part and Inventory Search

Back
Top