Stack Overflow
Stack Overflow

Questions tagged [plsql-psp]

Oracle PL/SQL Server Pages

PL/SQL Server Pages (PSP) are server-side scripts that include dynamic content, including the results of SQL queries, inside Web pages. You can author the Web pages in an HTML authoring tool and insert blocks of PL/SQL code.

Deploying content through PL/SQL Server Pages has the following advantages:

  • For developers familiar with PL/SQL, the server pages are the easiest way to create professional Web pages that included database-generated content. You can develop Web pages as normal and then embed PL/SQL code in the HTML.

  • PSP can be more convenient than using the HTP and HTF packages to write out HTML content line by line.

  • Because processing is performed on the database server, the client browser receives a plain HTML page with no special script tags. You can support all browsers and browser levels equally.

  • Network traffic is efficient because use of PSP minimizes the number of database round-trips.

  • You can write content quickly and follow a rapid, iterative development process. You maintain central control of the software, with only a Web browser required on the client machine.

15 questions
1
vote
2 answers

PL/SQL Server Pages - How does it compares to other technologies (e.g. PHP)? How popular is it?

Today my university lecturer in a databases class brought up PSP. I have used the LAMP stack and am into open source, so I have a bias against Oracle. I understand however, that Oracle databases are used in industry and so it is good to learn how…
Portablejim
  • 824
  • 1
  • 12
  • 21
1
vote
2 answers

exact fetch returns more than requested number of rows in a triger execution

I am creating a trigger for auto_generating prod_id from prod_summery the given table is PROD_ID CHAR(8 BYTE) No 1 PRODUCT_TITLE VARCHAR2(30 BYTE) No 2 PRODUCT_SUMMERY VARCHAR2(150 BYTE) No 3 INTEREST_TYPE CHAR(1…
Saumya Ranjan
  • 75
  • 1
  • 3
  • 11
1
vote
1 answer

How to Find Memory Leaks in PL/SQL code

I'm in Software Configuration Management Team. I'm so curious to find Memory leaks in PL/SQL. Do we have any specific tools?.or any other method to find this. If so, i can put it in the process of after checkin and intimate to users on the memory…
John
  • 15
  • 2
1
vote
0 answers

Tuning SQL Query which returns REF CURSOR

I am using reference cursor in function to return values. This function is getting called recursively for different input values. My package Definition is as follows. create or replace PACKAGE AI_QUERY_EXECUTION_PKG IS TYPE…
Shriraj
  • 133
  • 4
  • 11
1
vote
1 answer

how do you call a procedure and get its variables in pl/sql

so I am trying to create a game blackjack in plsql, i plan on using 2 procedures that will give me values such as king of spade, 2 of hearts, etc. The main part is the problem where i create the loops and such, I CANNOT CALL THE PROCEDURE. I tried…
Mr. newbie
  • 11
  • 2
0
votes
1 answer

How can I convert CURL command to PL/SQL?

I have a curl command, and I need to use this command in my program using PL/SQL. This is the command: curl -X 'POST' \ 'https://gw-fatoora.zatca.gov.sa/e-invoicing/developer-portal/compliance' \ -H 'accept: application/json' \ -H 'OTP:…
Pythoner-sh
  • 134
  • 6
0
votes
2 answers

pl/sql-create trigger on a table -whenever a new record is inserted in the same table another column of the table should be updated

create trigger calculation after insert on employee for each row begin if :new.updated_sal is null then update employee set updated_sal= (10/100)* salary where id=:new.id; end if; end; I would like to create a trigger on the employee table,…
user17448656
  • 1
0
votes
1 answer

passing parameters between a psp and a html page

i have a psp(plsql server page) to which a parameter called p_user_name is passed as shown below: i have created a local variable called p_user in the page as shown below: <%@ plsql procedure="recon_portal" %> <%@ plsql parameter="p_menu" …
GOUTHAMI
  • 1
  • 1
0
votes
2 answers

PL SQL Temporary Table

I need to create a key-value pair in PL SQL. I know that Oracle doesn't have the same concept of temporary tables as SQL Server does but it'd help me to convert a split string into a hash, array or similar to process it. My problem is that, every…
Jaquio
  • 183
  • 1
  • 11
0
votes
1 answer

PL/SQL PSP Form not submitting values

I am pretty sure this is a syntax error I'm just not seeing it. I have a form to submit payment information to the database and load that into the invoice table. My output line is just to test what is coming through. The table receives an…
kate8895
  • 27
  • 1
  • 4
0
votes
2 answers

requirements for Oracle HTTP Server

For a personal project, I am trying to create a web page which displays some information from a database. In order to have OHS, up and running, is it necessary to have already installed Oracle WebLogic Server? Thanks,
mikcutu
  • 1,013
  • 2
  • 17
  • 34
0
votes
1 answer

PLS-00103: Encountered the symbol "BEGIN"

I want to create a function that return the power of a given number, the SQL developer keep giving me this error : PLS-00103: Encountered the symbol "BEGIN" Errors: check compiler log Here's my code CREATE OR REPLACE FUNCTION Power(x NUMBER,n…
Abdelhak
  • 176
  • 2
  • 12
0
votes
1 answer

Hierarchical table merge itself many times

CREATE TABLE b( ID VARCHAR2(50 BYTE), PARENT_ID VARCHAR2(50 BYTE), NAME NVARCHAR2(200) ); https://community.oracle.com/thread/3513540? Above link i explained everything
user3283992
  • 1
0
votes
1 answer

PL/SQL Server Page cannot find form

For some reason, this code does not work. It cannot find "User.ex6a1_order_receipt". However, if I type the URL in manually I can navigate to it. What am I doing wrong? This is the complete error. The requested URL…
user1729696
  • 311
  • 2
  • 5
  • 16
-1
votes
1 answer

expression of wrong type oracle error

I am trying to execute the below plsql program, but facing expression of wrong type. Could anyone let me know what might be the error? CREATE OR REPLACE PROCEDURE CLN_TBL (CTRLM IN VARCHAR2, CTG IN VARCHAR,SBCT IN NUMBER, RTDT IN NUMBER ) AS …
pyennamp
  • 11
  • 4