Sitemap

Amicuk Programming Answers

How can we update procedure in Database Directly

2015-10-11   Views:0

Advertisement

Hi Experts how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that W

Hi Experts
how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that When I run the report It automatically create stored procedure . or other simple way to create stored procedure
Regards
Gorge
Edited by: Gorge Ance on May 13, 2009 8:09 AM

The replay answer
Advertisement
Hi
If your field match what you have in demo and production ,all you need to do is run that stored procedure pointing to correct database .So you probable have to change alter to create .
When you go to sql server , you have a choice to run a query of stored procedure  against the particular dtabase while you use query analyser .
In crystal report , you have to manually change the datasource and update store procedure.
Your report will now point to production database and point to correct stored procedure .
Hope this helps
Bishal

Go to See the other 4 answers

How can we update procedure in Database Directly

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that W[More]

Update procedure from APEX 3.1 to 3.1.2 on Oracle XE database

Category:DefaultRelease time:-0001-11-30Views:130

Hello, how to make an update of APEX 3.1 to 3.1.2 on an Oracle XE database with the full installation pack (which you get normally at OTN)? I mean the patchset 7313609 from Metalink wont work on a XE database because it doesn't have the opatch featur[More]

Block with more than one table type agurment -  Update Procedure for Block

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have one form with 3 Block. First Block is single row block, and other 2 are details block . The details balocks are based on the Procedure datasource, because of the complex query conditions. Now my requirement is When Inserting / Updating the[More]

U430 BIOS Update Procedure (fixes wake from sleep issue on Windows 8.1)

Category:DefaultRelease time:2015-10-11Views:130

Hopefully this will make the BIOS update process a bit easier.  The following steps address two common questions (Failed BIOS Update and the Windows message about improperly configured Secure Boot).  NOTE: After a successful BIOS update you will want[More]

Error Stored Procedure Upgrading database from SBO 2007A PL42 to SBO 8.8

Category:DefaultRelease time:2015-10-11Views:130

Hi, When executing the SBO 8.8 PL00  upgrade procedure for databases for an "old" database 2007A PL 42, upgrtade stops whith an error concerning a missing stored procedure "_TmSp_CorrectWrongDocLineNumberInOINMForIPF which is not found"[More]

How Do I Make Updated Procedure in the Program Unit of the Form to Work?

Category:DefaultRelease time:-0001-11-30Views:130

I have updated a procedure in the Program Unit of the Form that I modified. I am not sure what are the proper ways to compile or load the changed procedure in my form to make sure the changes work. Please help me with the following questions: Do I ha[More]

Data is not updated in the database

Category:DefaultRelease time:2015-10-11Views:130

hi.. to all.. i'm using the following code ...... but the data is not updated in the database.. the output window get closed as soon as i clicked save button... i don't know wat's problem with the program... Plz help me.. to get resolve this problem.[More]

How to extract data from oracle database directly in to bi7.0 (net weaver)

Category:DefaultRelease time:2015-10-11Views:130

how to extract data from oracle database directly in to bi7.0 (net weaver)? is it something do with EDI? can anybody explain me in detail? Thanks YorkYou can use UDConnect to get from Oracle database in to BW <b>Data Transfer with UD Connect -</b[More]

Updating values in database table through Transaction

Category:DefaultRelease time:2015-10-11Views:130

Hi, Actually We have one transaction named EWAWA01. In that when we display the values from the transaction, there is a netweight field. The transaction displaying netweight values, but that value is not updated in the database table named EWA_WA_WEI[More]

IPhoto version 9.4.3 update procedure is not responding.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a problem concerning a normal software update. I have a MacBook Pro runnig OS X 10.8.3 (12D78). Two days ago i got a normal message telling that there is an update available for a new verson of iPhoto (9.4.3) Everything went as normal to t[More]

Getting result set from stored procedures in database controls in weblogic

Category:DefaultRelease time:2015-10-11Views:130

I am calling a stored procedure from database control which actually returns a result set when i call the stored procedure like * @jc:sql statement="call PROC4()" ResultSet sampleProc() throws SQLException; it gives me exception saying "web[More]

Hot
Hi experts, I need a report for changes of Equipment Master for a document. There is a way to reach this for every document : Environement - > Display Changes. Then I can get a report for "Changes to Object Links". But this can only show me t [More]
My brand new ipod times out every ten min or so and drops the wifi connection. This really ***** because that means I do not get my email or messages. Sort of makes the device an expensive desk weight. Does anyone know of an app for 4.2 or a workarou [More]
After making adjustments in Lightroom 3.2, if I then edit the image in Photoshop CS4, the image rotates slightly clockwise and affects any cropping and adjustments to the vertical I have already done in Lightroom. The rotation occurs as the image is [More]
Wow, what a joke Verizon is becoming! Been waiting a week now for my DSL, they say " there are not enough ports available"...{word filter avoidance} does that mean???  Anyone else in this part of the world (45309) having problems with VerizoN? I [More]
hi, please, maybe can anybody help me..... I've got some textfields (JTextField) in a swing-application. by jumping in another textfield through pressing the tab-key, something should happen. I wrote the following code, but it doesn't works ;-( textf [More]
Hi, We can see BO XI 3.1 SP3, the execution time for a report is faster. is it using BOXI Enterprise APIs to determine the start and end? How is calculated? thx auroraHi, this forum is for the SAP BusinessObjects BI Solution Architecture. I would sug [More]
I have an older version of pr it cam with a bundle, photo shop and illstrator work but when I start PR it gets to open new or existing project and then a box comes up saying windows is working on your problem and dies. Is there a work around or a fil [More]
hi all, I am using signed applet, i given all permission and all socket permission , still i am getting following error. java.security.AccessControlException: access denied (java.net.SocketPermission 192.168.0.222:6060 connect,resolve)      at java.s [More]
Hi, I am not sure how to resolve or i don't how to approach this. i click on debug and view debug buttons still not able to find. What are these line numbers indicates. where to see them ORA-06512: at "SYS.WWV_DBMS_SQL", line 12 ORA-06512: at &q [More]
My late 2013 Macbook Pro using 10.10.2 is crashing pretty much on a daily basis.  I am using Aperture 3.6.  Always seems to happen when I am using Aperture.  Then have to repair the library for inconsistencies.  Does anyone else have these problems? [More]