تحميل جافا الى ال Pl/sql

[wael200516]

السلام عليكم يا اخوانى
اريد منك المساعده فى عملية انشاء كلاس فى ال PL/SQL
توجد معى package انا عملتها عندما احاول ان شاء ال function
يطلع لى خطاء وهو ان ال package حقى مش موجوده الرجاء المساعده فى الحل


CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "MyApplication" AS
import edu.sz.ie.*;
import edu.sz.ie.bw.*;
import java.util.List;
import java.io.IOException;

هنا باقى الكود عادى مافى مشكله

هناا نلاحظ ان

edu.sz.ie.*;
edu.sz.ie.bw.*;
هذول ال package تبعى

بالنسبة لل
import java.util.List;
import java.io.IOException مافى مشكله

السوال كيف اصيفى ال package الى اوراكل
او هناك طريقه معينة

[Mahmoud Ahmed El-Sayed]

you import another package that should be loaded in java classes

import edu.sz.ie.*;
import edu.sz.ie.bw.*;

You should load java classes before compile your Java Source

use below link which would guide you to load java classes

http://docs.oracle.com/cd/B10501_01/java.920/a96659/02_load.htm

[wael200516]

you import another package that should be loaded in java classes

import edu.sz.ie.*;
import edu.sz.ie.bw.*;

You should load java classes before compile your Java Source

use below link which would guide you to load java classes

http://docs.oracle.c...659/02_load.htm

الف شكر اخى و لكن عندما اقوم بتحميل الكلاس الى داخل اوراكل
كيف استطيع ان اعمل
import edu.sz.ie.*;

اى ان الكلاس ليس دخل package
كماهو فى هذا الامر
import edu.sz.ie.*;
هل اكتب فقط
import follow by class name

وشكرا تم تعديل 8 أبريل 2012 بواسطة wael200516

[Mahmoud Ahmed El-Sayed]

Every class may have package name like edu.sz.ie , so when you import class oracle internal know the package name in class

At general if you import class with package names then you must import using package name, otherwise if you import class with class only the you must import by class name only because he hasn't package

Note package name is written in class code

[wael200516]

Every class may have package name like edu.sz.ie , so when you import class oracle internal know the package name in class

At general if you import class with package names then you must import using package name, otherwise if you import class with class only the you must import by class name only because he hasn't package

Note package name is written in class code

Many thanks brother

[Mahmoud Ahmed El-Sayed]

Every class may have package name like edu.sz.ie , so when you import class oracle internal know the package name in class

At general if you import class with package names then you must import using package name, otherwise if you import class with class only the you must import by class name only because he hasn't package

Note package name is written in class code

Many thanks brother

Thanks Wael about your appreciation , I will post new article about using java in PLSQL nearly

[wael200516]

Many thanks dear Mahoud

Please see this question

http://www.araboug.org/ib/index.php?showtopic=49648